How can I find out if a MySQL query has returned to PHP?

Question

I am using PHP5 and MySQL. I use functions mysql_...().

Answer 1

if (mysql_num_rows($query_identifier) == 0)
  echo "Query returned 0 rows";

In addition, mysql_query () returns falsein case of an error.

Guide: MySQL functions in PHP

Answer 2

If you use mysqli_ functions, you can call $ stmt-> num_rows () . But only after calling $ stmt-> store_result () to ensure that all rows have been returned.