Welcome Guest, Not a member yet? Register   Sign In
SQL Query returns no results (but it's there!)
#7

[eluser]siptik[/eluser]
it's strangely!
Your code works fine for me!

Code:
echo $this->db->query("SELECT * FROM listings WHERE  from_email = '[email protected]'")->num_rows();
echo $this->db->last_query();

2 SELECT * FROM listings WHERE from_email = '[email protected]'

I have two rows in database where from_email = '[email protected]'




Messages In This Thread
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 10:22 AM
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 11:01 AM
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 11:09 AM
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 11:29 AM
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 11:33 AM
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 11:51 AM
SQL Query returns no results (but it's there!) - by El Forum - 11-03-2012, 12:00 PM



Theme © iAndrew 2016 - Forum software by © MyBB