How to find out if nothing is returned from query

[cliftonbazaar]

I have the following code

$results=mysqli_query($mysqli, $sql_statement);

and I wish to find out what happens if no results are returned.

 

I have tried

if(!$results) echo "Hello";

but nothing ever gets printed out

So how can I find out if $results is empty?

 

James

[trq]

The general syntax is:

 

if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    // free to use $result
  } else {
    // no result found
  }
} else {
  // query failed
}

[cliftonbazaar]

Thanks for that, works perfectly