Unexpected reource ID from a SELECT query

[jaisol]

I have the following code its from a php function.

$query3	=	"SELECT * FROM `client` WHERE `c_fname`	= 'brick' LIMIT 0, 2";
$dog	=	mysql_query($query3);
echo "<br> query result {$dog}";

 

The above code returns a resource ID I was expecting it to return false as there is no "brick" in the colum c_fname.  Anyone know why its returning a resource id?

[Alex]

What makes you think it would return false? As you can see from the manual, mysql_query only returns false if the query fails or if the user does not have sufficient privileges to access the table.

[PFMaBiSmAd]

The value from a mysql_query() will only be FALSE if the query fails due to an error (i.e. no connection to the database server, no database selected, a syntax error in the sql, a duplicate key...)

 

A query that executes without any errors but matches zero rows is a successful query and returns a result resource, but the result set contains zero rows in it. You can use mysql_num_rows() to find out how many rows are in the result set.

[jaisol]

Many thanks

I'll count the rows to check my results, I wrongly thought if the query returned 0 rows then it would be unsucessful. I've learned otherwise .. LOL