MySQL Error: Commands out of sync; you can't run this command now

Question

MySQL Error: Commands out of sync; you can't run this command now

I get the above error when I try to execute an SQL Procedure more than once each time.

I've found that it has something to with the "store result", so I've been trying to figure it out for a while, but I haven't succeeded yet.

Here is my PHP code:

$query = "CALL GetObjectsValue(".$FormID.")";

if( $res = $mysqli->query($query) )
{
    $mysqli->store_result();

    while ($row = $res->fetch_assoc()) 
    {

        ...

    }
    $res->free();
}

Try this http://stackoverflow.com/a/32837401/2096041 – Barry Staes Sep 29 '15 at 06:50 — Barry Staes, Sep 29 '15 at 06:50

sbrbot · Answer 1 · 2015-05-10T11:27:21.507

0

For some reason, for recordset from stored procedures one has to loop through it using next_result() command. This is not the case if recordset comes directly by execution of SQL query (SELECT).

$query="CALL GetObjectsValue($FormID)";
if($res=$mysqli->query($query))
{
  do
  {
    $row = $res->fetch_assoc()
    ...
  }
  while($mysqli->next_result()); //loop through recordset

  $res->free();
}

edited May 10 '15 at 11:27

answered May 10 '15 at 11:07

sbrbot

6,169
6
43
74

score -2 · Answer 2 · edited Oct 16 '13 at 15:50

-2

Change

$query = "CALL GetObjectsValue(".$FormID.")";

to

$query = "CALL GetObjectsValue("$FormID")";

Notice the $FormID without the dots.

edited Oct 16 '13 at 15:50

Litmus

10,558
6
29
44

answered Oct 16 '13 at 15:23

felipe

1

2

The dots are string concatenation in PHP - they are necessary – Izkata Oct 16 '13 at 15:52
your example will result in syntax error, as dots are concatenation operators – webdevbyjoss Oct 16 '13 at 15:54

MySQL Error: Commands out of sync; you can't run this command now

2 Answers2

Linked