RE: [PHP-DB] checking for 0 results?
| From: | Aaron Wolski | Date: | Fri, 15 Nov 2002 13:41:31 +0000 |
| Subject: | RE: [PHP-DB] checking for 0 results? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-23363@lists.php.net to get a copy of this message | ||
Or you can skip a step like:
$sql = "select * from ietsfuckingfriday";
if (mysql_num_rows($result) == 0) {
do_something();
} else {
do_anotherthing();
}
Aaron
-----Original Message-----
From: Snijders, Mark [mailto:Mark.Snijders@atosorigin.com]
Sent: November 15, 2002 8:26 AM
To: 'Jonathan Narong'; php-db@lists.php.net
Subject: RE: [PHP-DB] checking for 0 results?
$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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php