$sql = "select * from ietsfuckingfriday"; $result = mysql_query($sql); $num_rows=mysql_num_rows($result); if ($num_rows==0)echo "yesss we did it"; (sorry it's friday :-) almost can go home :--) -----Original Message----- From: Jonathan Narong [mailto:jon@binaryillusions.com] Sent: vrijdag 15 november 2002 14:23 To: php-db@lists.php.net Subject: checking for 0 results? maybe i'm totally not thinking straight right now, but is there a way in php to check if 0 results are returned in a mysql query? for example, i have a definition database, that has a list of letters the user clicks on (click on the letter, and all the terms for that letter pop up).. but for some letters there are no terms. so i just wanted to echo out a simple "no terms" message or something. in any case, i need to check if there are no results from a mysql query (an error won't be returned). thanks .. -jon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
