Aaron was right initially: $sql = "select * from ietsfuckingfriday"; $result = mysql_query($sql); $num_rows=mysql_num_rows($result); Somewhere along the line, things got convoluted, but that's how you check for 0 rows returned from a query. > -----Original Message----- > From: Snijders, Mark [mailto:Mark.Snijders@atosorigin.com] > Sent: Friday, November 15, 2002 8:45 AM > To: 'Aaron Wolski'; 'Jonathan Narong'; php-db@lists.php.net > Subject: RE: checking for 0 results? > > > and how does $sql now gets in touch with $result???? > > > > > 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
