Commands out of sync; you can’t run this command now

You can’t have two simultaneous queries because mysqli uses unbuffered queries by default (for prepared statements; it’s the opposite for vanilla mysql_query). You can either fetch the first one into an array and loop through that, or tell mysqli to buffer the queries (using $stmt->store_result()).

See here for details.

Related Posts:

  1. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  2. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  3. PDO with INSERT INTO through prepared statements
  4. Creating a search form in PHP to search a database?
  5. How can I do ‘insert if not exists’ in MySQL?
  6. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  7. MySqli Commands out of sync; you can’t run this command now
  8. How can I do ‘insert if not exists’ in MySQL?
  9. mysqli::query(): Couldn’t fetch mysqli
  10. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  11. Deprecated: mysql_query() [duplicate]
  12. Fatal error: Call to a member function query() on null
  13. Having a problem getting mysqli_query to execute
  14. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  15. How to use mysqli_query() in PHP?
  16. How to log in to phpMyAdmin with WAMP, what is the username and password?
  17. Fatal error: Call to undefined function mysql_connect()
  18. PDOException SQLSTATE[HY000] [2002] No such file or directory
  19. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  20. PDOException SQLSTATE[HY000] [2002] No such file or directory
  21. Mysql query- How to use contains?
  22. Data source name not found, and no default driver specified
  23. Invalid column count in CSV input on line 1 Error
  24. Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, object given in
  25. Invalid column count in CSV input on line 1 Error
  26. mysqli_real_connect(): (HY000/2002): No such file or directory
  27. Fatal error: Call to undefined function mysqli_connect()
  28. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  29. phpMyAdmin: secret passphrase?
  30. PDO bindParam() with prepared statement isn’t working
  31. Forbidden :You don’t have permission to access /phpmyadmin on this server
  32. mysqli_real_connect(): (HY000/2002): No such file or directory
  33. Fatal error: Call to undefined function mysqli_connect()
  34. Trying to get property of non-object in
  35. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  36. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  37. Call to undefined method mysqli_stmt::get_result
  38. Call to undefined method mysqli_stmt::get_result
  39. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  40. Cannot simply use PostgreSQL table name (“relation does not exist”)
  41. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  42. How can I prevent SQL injection in PHP?
  43. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  44. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  45. Fatal error: Cannot use object of type mysqli_result
  46. How to solve “Fatal error: Class ‘MySQLi’ not found”?
  47. mysql_field_name to the new mysqli
  48. Object of class DateTime could not be converted to string
  49. What does it mean to escape a string?
  50. Convert from MySQL datetime to another format with PHP
  51. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  52. mysqli_select_db() expects parameter 1 to be mysqli, string given
  53. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  54. phpMyAdmin ERROR: mysqli_real_connect(): (HY000/1045): Access denied for user ‘pma’@’localhost’ (using password: NO)
  55. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  56. Call to a member function on null?
  57. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  58. MySQL query to get column names?
  59. What does MYSQLI_NUM mean and do?
  60. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  61. What is the advantage of using try {} catch {} versus if {} else {}
  62. select * from table where column = value ^ column2= value
  63. Object of class mysqli_result could not be converted to string
  64. No query results for model [App\Products] Laravel
  65. Fatal error: Call to a member function fetch_assoc() on a non-object
  66. mysqlworkbench giving version error on exporting database
  67. How to make DROP INDEX IF EXISTS for mysql?
  68. What is the meaning of sprintf(): Too few arguments
  69. Can I store images in MySQL 
  70. MySQL Daemon Failed to Start – centos 6
  71. Warning: mysqli_real_escape_string() expects exactly 2 parameters, 1 given… what I do wrong? 
  72. How to remove index.php from WordPress site URL
  73. PHP Like thing similar to MySQL Like, for if statement?
  74. How get value from URL
  75. Call to a member function fetch_assoc() on boolean in [duplicate]
  76. How to use Memcached with PHP7?
  77. select count(*) from table of mysql in php
  78. PHP variables don’t evaluate in the query [duplicate]
  79. 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
  80. Transaction when using WP functions rather than vanilla SQL?
  81. How to get the list of WooCommerce product image of a certain category from database?
  82. How to make WordPress plugin check for database changes and then do something?
  83. How to Join two tables from separate databases within WordPress
  84. Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
  85. What SQL / WordPress queries would need a nonce?
  86. Importing Geo data into wordpress database
  87. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  88. $wpdb->insert() does not Insert record in a table
  89. Use $wpdb or other PHP script method to find/replace in WP database
  90. How can I add a new row in a separate database when someone registers via WordPress?
  91. Use variable in SQL statement
  92. mySQL queries are executed twice on wordpress website
  93. making php value numeric
  94. Database SQL query error
  95. How to run complex query using PHP
  96. How to get database connection details without longing to cpanel in WordPress?
  97. Inserting other fields to existing registration form in a WordPress theme
  98. SQL Query Search page
  99. can’t delete a row from post_meta table
  100. Conditional statement within WP SQL query

Leave a Comment

error code: 523