Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result [duplicate]

by

Your query must have a problem which is causing $result to be an invalid resource.

Try checking for mysql_error() after the line on which you run your query.

Edit:

In fact, I would alter your DBConnector class function query() to something like the following, so that an identifiable error is thrown when you have a bad query:

function query($query) {
    $this->theQuery = $query;
    $queryId = mysql_query($query,$this->link);
    if (! $queryId) {
        throw new Exception(mysql_error().".  Query was:\n\n".$query."\n\nError number: ".mysql_errno();
    }
    return $queryId;
}

More Related Contents:

  1. How to create this type of JSON data from PHP [closed]
  2. how to write php code for the key press enter button when fill the form?
  3. Create hyperlink from html table row to open record on a new page
  4. mysql_fetch_array(): supplied argument is not a valid MySQL result resource [duplicate]
  5. I don’t know what’s wrong with my code. I’m a newbie. The prob is – Notice: Undefined variable: result [duplicate]
  6. SELECT COUNT(*) AS count – How to use this count
  7. How to execute two mysql queries as one in PHP/MYSQL?
  8. How to resolve ambiguous column names when retrieving results?
  9. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  10. Maximum execution time in phpMyadmin
  11. PHP PDO – Num Rows
  12. Post and get at the same time in php
  13. MySQL – Access denied for user [duplicate]
  14. Calling stored procedure with Out parameter using PDO
  15. Setting up Laravel on a Mac php artisan migrate error: No such file or directory [duplicate]
  16. How to display an BLOB image stored in MySql database?
  17. What is the best way to insert multiple rows in PHP PDO MYSQL?
  18. How to bind LIKE values using the PDO extension?
  19. How do I set the selected item in a drop down box
  20. Fatal error: Call to undefined function mysqli_result()
  21. access denied for user @ ‘localhost’ to database ” [closed]
  22. Warning: PDO::__construct(): [2002] No such file or directory (trying to connect via unix:///tmp/mysql.sock) in
  23. WordPress Fatal error: Uncaught Error: Call to undefined function mysql_connect() in /wp-includes/wp-db.php:1570
  24. How can I employ “if exists” for creating or dropping an index in MySQL?
  25. PHP MySQL pagination with random ordering
  26. How do you make good use of multicore CPUs in your PHP/MySQL applications? [closed]
  27. Update query PHP MySQL [duplicate]
  28. Do I have to use mysql_real_escape_string if I bind parameters?
  29. How to get a list of databases?
  30. How to sort MYSQL fulltext search results by relevancy

Leave a Comment