test for empty query_result variable

[audiolizard]

I'm using a query to pull records from a database and display them on a webpage. I want to set up a conditional so that when no results are returned I display a message instead of a blank page. I'm sure this is easy, but nothing I've tried seems to work.

$query = "query...";
$query_result = mysql_query($query, $db_connection);
if(CONDITIONAL){
while ($row = mysql_fetch_array($query_result, MYSQL_ASSOC)){
//do stuff with $row
}
}else{
echo "No results were found";
}

What should I use for CONDITIONAL?

I've tried:
if($query_result){
if($query_result != NULL){
if($query_result != ""){

but I still just get a blank page if there are no results found.
So what should I use instead?

[Oleg Butuzov]

Code: Select all

if (mysql_num_rows($result) != "0")
{

}