How to determine if query returns info...

[s_o_d]

Hello...
When querying a database, how can you tell whether or not the query actually returns any information? Possibly to output a notice that no information was returned.

thanks,
sod

[aspen]

$numResults = mysql_num_rows($result);
if($numResults == 0){
blah blah
}else{
blah blah
}

[s_o_d]

Thanks a lot...that's exactly what I needed. I had no idea that function existed..guess I should go on php.net more often..

[d-net]

I usually use this instead...is it a problem?

if ($result)
{
blah blah
}
else
blah

[TravisB]

That works for me, although the former example is possibly more correct.

[aspen]

d-net your code will tell you if the query was successfully executed. It can be successfully executed and still return 0 results. Basically what you're doing is used for error handling.

The code I posted is what you'd use to see if the query returned any results at all, assuming it was successfully executed.