Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
March 17, 2008, 8:22 pm
rate this thread
My problem is, that after calling a mysql stored procedure i cannot
make another query. I get "Commands out of sync; you can't run this
command now" error. See the code below:
$mysqli = new mysqli(DB_Host,DB_User,DB_Pass,DB_Name) or die('DBError
- Could not connect!');
$result = $mysqli->query("call appGetPage(1)") or die('DBError -
$result = $mysqli->query("select now()") or die('DBError -
The output is the fallowing for this:
DBError - 2
Commands out of sync; you can't run this command now
So i tried to make it with non object, plain old mysqli_... commands,
i tried to execute it in real_query and a few things other, even tried
to get it to work on another server, i googled around the world, but
My system is:
As i mentioned i tried on another config also, and obviously the
problem s somewhere at the mysql client in php.
Also tried on php5.2.3, php5.2.4, php5.3 but the same :(.