mysql_num_rows(): supplied argument is not a valid MySQL result resource [duplicate]

by

You need to check the return value of mysql_query

$query = 'YOUR QUERY';
$result = mysql_query($query);
if (!$result) {
    trigger_error('Invalid query: ' . mysql_error()." in ".$query);
}
// go ahead and fetch the results using mysql_num_rows.

If mysql_query fails it returns boolean false instead of a resource.

When you pass this boolean value to mysql_num_rows you get this error.

More Related Contents:

  1. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘WHERE `id` [closed]
  2. How can create Database using url or other method [duplicate]
  3. Problame with files on SQL
  4. Im trying to create some temporary tables in mysql using php
  5. How can I prevent SQL injection in PHP?
  6. SQL injection that gets around mysql_real_escape_string()
  7. How to include a PHP variable inside a MySQL statement
  8. How to apply bindValue method in LIMIT clause?
  9. SELECT COUNT(*) AS count – How to use this count
  10. Achieve hierarchy, Parent/Child Relationship in an effective and easy way
  11. selecting unique values from a column
  12. How to search for slash (\) in MySQL? and why escaping (\) not required for where (=) but for Like is required?
  13. I cannot get my login form to connect interact properly with mySQL database [closed]
  14. MySQL “NOT IN” query 3 tables
  15. Increment value in MySQL update query
  16. Create a dynamic mysql query using php variables
  17. How to separate DATE and TIME from DATETIME in MySQL?
  18. Do SQL connections opened with PDO in PHP have to be closed
  19. How to convert ISO8601 to Date format in php
  20. MySQL skipping first row
  21. How to reverse order output of a MySQL query
  22. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  23. How to generate unique id in MySQL?
  24. Fatal error: Call to a member function query() on null
  25. How would I implement a simple site search with php and mySQL?
  26. Do I have to use mysql_real_escape_string if I bind parameters?
  27. SELECT row by DATEPART()
  28. UNION syntax in Cakephp
  29. How do i search from serialize field in mysql database?
  30. PDO and MySQL ‘between’

Leave a Comment