執行mysql預存程序後Commands out of sync; you can't run this command now

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();?> 

