Doh!
Edit:
if (mysql_num_rows($sql) == 0) {
Aaron
-----Original Message-----
From: Aaron Wolski [mailto:aaronjw@martekbiz.com]
Sent: November 15, 2002 8:42 AM
To: 'Snijders, Mark'; 'Jonathan Narong'; php-db@lists.php.net
Subject: RE: checking for 0 results?
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: 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: 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
--
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
