执行mysql存储过程后Commandsoutofsync;youcan'trunthiscommandnow

php调用存储过程后再执行sql就提示Commands out of sync; you can't run this command now，请问是什么问题？

回复内容：

php调用存储过程后再执行sql就提示Commands out of sync; you can't run this command now，请问是什么问题？

要解决这个问题，需要用mysqli的multi_query方法

';
$mysqli->autocommit(FALSE);
if ($mysqli->multi_query("call test1();")) 
{
    do {
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_row()) {
                printf("%s\n", $row[0]);
            }
            $result->close();
        }
    } while ($mysqli->next_result());
}
$mysqli->commit();
echo "
";
echo "result2:
";
if ($result2 = $mysqli->query("select val from tb1;")) 
{
    while ($row = $result2->fetch_row()) {
        printf ("%s 
", $row[0]);
    }
    $result2->close();
}
else
{
    echo $mysqli->error;
}
$mysqli->close();
?>