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

[Kris Oye]

I had this problem, too. It was usually caused by a stored procedure that returned more than one dataset (ala Martijn). I added a quick little function to clear out results to prepare a connection for re-use.

function mysqli_clean_connection($dbc)
{
while(mysqli_more_results($dbc))
{
if(mysqli_next_result($dbc))
{
$result = mysqli_use_result($dbc);
mysql_free_result($result);
}
}
}

After adding it, though, I didn't see that message again... from this particular problem, anyway.