$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: [EMAIL PROTECTED]
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

Reply via email to