Can anyone please tell me what mysql returns if no records are found?
Here is what I am doing:
$query = "select from ....";
$result = mysql_query($query);
if (!$result) :
print "Could not find data!";
endif;
if($result){ blah blah...}

It seems to skip my error message. Any ideas?
Thanks in advance,
Ken

Looks like you're coding in PHP, right? Admittedly I'm a PHP newbie myself but...

According to the users manual (http://us2.php.net/manual/en/function.mysql-query.php), mysql_query only returns False if the query fails. So if your query is runnable, $result will have a return value even if there are no results.

Instead of if(!$result), try using if(!mysql_fetch_row($result)) That should evaluate to true if there are no result rows.