Why I am getting the Error "Commands out of sync; you can't run this command now"

Question

The Documentation of the Error Mentioned in the Title Says If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). It can also happen if you try to execute two queries that return data without calling mysql_use_result() or mysql_store_result() in between. From here: http://dev.mysql.com/doc/refman/5.0/en/commands-out-of-sync.html But In First Query I am not fetching any data from mysql database, I am just inserting. And In second Query I am getting the data from database. Here is My code ``` $connection = mysqli_connect("localhost","username","password","tbl_msgs"); if(mysqli_connect_errno($connection)) { die("Failed to connect to MySQL: " . mysqli_connect_error()); } $query = "INSERT INTO users (total_comments, total_views) VALUES ({$total_comments}, {$total_views}…

Accepted Answer

There are result set pending from the query:

mysqli_multi_query($connection,$query);

You need to use/store result before you can proceed with next query after: Since you look like you don't really care about the first result set, do this after the multi query..

```
do
{
    $result = mysqli_store_result($connection);
    mysqli_free_result($result);
}while(mysqli_next_result());
```

Another alternative is to close the connection and starts it again..

```
mysqli_close($connection);
$connection = mysqli_connect("localhost","username","password","tbl_msgs");
```

It all depends on your requirements.

Why I am getting the Error "Commands out of sync; you can't run this command now"

Solution

Problem