[SOLVED] checking to see if select returns nothing

[envexlabs]

Hey,

 

I have a query:

 

SELECT * FROM `table` WHERE `ID` = 5;

 

If the query doesn't return anything, ie. ID #5 doesn't exist, how do i check that?

 

Thanks,

 

envex

[wildteen88]

You'd use the PHP function called mysql_num_rows, this function will return how many results have been returned from the query, eg:

$sql = 'SELECT * FROM `table` WHERE `ID` = 5';
$result = mysql_query($sql);

// check to see if the returned rows is greater than zero
if(mysql_num_rows($result) > 0)
{
   // result has been returned

  // process the results
}
else
{
   // no results was returned, we'll display a message
   echo 'No results returned';
}

[SnowControl]

mysql_num_rows($result)

 

Counts the number of rows used. Or:

 

mysql_affected_rows()

 

Same result. So:

 

if (mysql_affected_rows()==0) {

 

echo "This rows doesnt exist";

 

}

[envexlabs]

Thanks!