Use mysql_num_rows() to return the amount of rows selected with your query.
example:
<?php
/* DB connection stuff comes here */
$query = "SELECT * FROM table";
$getdata = mysql_query($query);
if(mysql_num_rows($getdata)){
// output fetched rows
}
else{
echo "no terms";
}
?>
"Jonathan Narong" <jon@binaryillusions.com> wrote in message
KLEHIEPKGMOHKIMODPDHAEBCCFAA.jon@binaryillusions.com">news:KLEHIEPKGMOHKIMODPDHAEBCCFAA.jon@binaryillusions.com...
> 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
