RE: [PHP-DB] checking for 0 results?
| From: | Snijders, Mark | Date: | Fri, 15 Nov 2002 13:25:53 +0000 |
| Subject: | RE: [PHP-DB] checking for 0 results? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23362@lists.php.net to get a copy of this message | ||
$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: [PHP-DB] 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