Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in

Your query ($myQuery) is failing and therefore not producing a query resource, but instead producing FALSE.

To reveal what your dynamically generated query looks like and reveal the errors, try this:

$result2 = mysql_query($myQuery) or die($myQuery."<br/><br/>".mysql_error());

The error message will guide you to the solution, which from your comment below is related to using ORDER BY on a field that doesn’t exist in the table you’re SELECTing from.

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  3. Fatal error: Call to undefined function mysql_connect()
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Mysql query- How to use contains?
  8. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  9. Invalid column count in CSV input on line 1 Error
  10. Invalid column count in CSV input on line 1 Error
  11. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  12. PDO with INSERT INTO through prepared statements
  13. phpMyAdmin: secret passphrase?
  14. PDO bindParam() with prepared statement isn’t working
  15. Forbidden :You don’t have permission to access /phpmyadmin on this server
  16. Creating a search form in PHP to search a database?
  17. How can I do ‘insert if not exists’ in MySQL?
  18. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  19. MySqli Commands out of sync; you can’t run this command now
  20. Trying to get property of non-object in
  21. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  22. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  23. Commands out of sync; you can’t run this command now
  24. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  25. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  26. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  27. How can I do ‘insert if not exists’ in MySQL?
  28. Object of class DateTime could not be converted to string
  29. What does it mean to escape a string?
  30. Convert from MySQL datetime to another format with PHP
  31. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  32. mysqli::query(): Couldn’t fetch mysqli
  33. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  34. Uncaught Error: Call to undefined function mysql_escape_string()
  35. Call to a member function on null?
  36. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  37. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  38. MySQL query to get column names?
  39. What does MYSQLI_NUM mean and do?
  40. Mysql where id is in array
  41. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  42. What is the advantage of using try {} catch {} versus if {} else {}
  43. select * from table where column = value ^ column2= value
  44. Deprecated: mysql_query() [duplicate]
  45. No query results for model [App\Products] Laravel
  46. Fatal error: Call to a member function query() on null
  47. mysqlworkbench giving version error on exporting database
  48. How to make DROP INDEX IF EXISTS for mysql?
  49. What is the meaning of sprintf(): Too few arguments
  50. Having a problem getting mysqli_query to execute
  51. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  52. Can I store images in MySQL 
  53. MySQL Daemon Failed to Start – centos 6
  54. How to insert TIMESTAMP into my MySQL table?
  55. How to remove index.php from WordPress site URL
  56. PHP Like thing similar to MySQL Like, for if statement?
  57. How get value from URL
  58. How to use Memcached with PHP7?
  59. select count(*) from table of mysql in php
  60. 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 ””)’ at line 2
  61. How to check if a string starts with a specified string?
  62. How do the PHP equality (== double equals) and identity (=== triple equals) comparison operators differ?
  63. Are PDO prepared statements sufficient to prevent SQL injection?
  64. Message: Trying to access array offset on value of type null [duplicate]
  65. retrieve data from db and display it in table in php .. see this code whats wrong with it?
  66. Count how many files in directory PHP
  67. Parsing domain from a URL
  68. PHP class not found but it’s included
  69. How to fix the session_register() deprecated issue?
  70. The character encoding of the HTML document was not declared
  71. Notice: Undefined offset: 0 in
  72. How to Sort a Multi-dimensional Array by Value
  73. How to get time difference in minutes in PHP
  74. How to write a link like which link to the same page in PHP?
  75. PHP + JQuery – How to use these two together? Please see my example
  76. Data extraction from /Filter /FlateDecode PDF stream in PHP
  77. How to use data-saferedirecturl in a tag in PHP?
  78. PHP date yesterday [duplicate]
  79. How to get the list of WooCommerce product image of a certain category from database?
  80. tag search using WP_Query
  81. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  82. How to convert objects into arrays
  83. Can’t get wp_insert_post to work
  84. mysql query from wordpress page using custom table
  85. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  86. Not connecting to database in file with multiple MySQL connections
  87. Way to bulk make all my tags lowercase?
  88. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  89. pagination on data fetched using SQL query
  90. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  91. email alert for product availability
  92. How do I prepare strings for insertions as values into a MySQL table?
  93. WordPress low speed after migrating to new host
  94. How to edit content in WordPress and the Polylang – plugin? – with demosite
  95. WordPress upload images not displaying
  96. MySQL database migration to WordPress
  97. Query Concatenation
  98. Display total count of products in orders of a specific order status
  99. Putting form result in my database
  100. How can I update a value of a field depending on outside source?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)