PHP: Catch empty MySQL result

You can simply use the function mysqli_num_rows(). This function returns the number of records (rows) containing your result:

$res = mysqli_query($db, "SELECT * FROM tab WHERE id > 80");
 
if (mysqli_num_rows($res) == 0) {
  echo 'There were no matches.';
} else {
  // output data
}

In this way, you can design your code, to show the user, if there were no hits.
Last update on 2020-09-15 | Created on 2012-11-24