Best way to check if mysql_query returned any results?

by 
if (mysql_num_rows($result)==0) { PERFORM ACTION }

For PHP 5 and 7 and above use mysqli:

if (mysqli_num_rows($result)==0) { PERFORM ACTION }

More Related Contents:

  1. save user images in MYSQL database by which method? [closed]
  2. Im trying to create some temporary tables in mysql using php
  3. the update query just update the last row and affect other with it’s value
  4. How to insert images into a database using PHP [closed]
  5. How to apply bindValue method in LIMIT clause?
  6. How to change mysql to mysqli?
  7. Importing CSV data using PHP/MySQL
  8. Convert latin1 characters on a UTF8 table into UTF8
  9. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  10. Do SQL connections opened with PDO in PHP have to be closed
  11. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  12. mysql select query within a serialized array
  13. mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in php [duplicate]
  14. Whats the easiest way to determine if a user is online? (PHP/MYSQL)
  15. What is the advantage of using try {} catch {} versus if {} else {}
  16. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  17. How to convert ISO8601 to Date format in php
  18. Algorithm for generating a random number
  19. return one value from database with mysql php pdo
  20. Trying to access array offset on value of type bool
  21. onbeforeprint() and onafterprint() equivalent for non IE browsers
  22. How to get a query error from prepare() in PDO PHP?
  23. How can I pass an array of PDO parameters yet still specify their types?
  24. Fatal error: Call to a member function query() on null
  25. MySQL & PHP Parameter 1 as Resource
  26. MySQL GROUP BY and Fill Empty Rows
  27. mysql injection damages?
  28. PHP PDO how to run a multiple query request?
  29. How to check if a value already exists to avoid duplicates?
  30. How to use MySQL Found_Rows() in PHP?

Leave a Comment