php mysql 쿼리 실행 오류 - Commands out of sync; you can't run this...

php mysql 쿼리 실행 오류 - Commands out of sync; you can't run this...

프로시저 실행후 쿼리를 실행하면 아래 오류 발생 가능성 있음

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

$conn = mysqli_connect($host, $user, $pass, $db);

$db_conn = mysqli_select_db($conn, $DBName);

....

$sql = " CALL USP_Appoint_Recommend() ";

$result = mysqli_query($conn, $sql);

(일반)

mysqli_next_result($conn);

(그누보드)

mysqli_next_result($g5['connect_db']);

from http://devlink.tistory.com/644 by ccl(A) rewrite - 2021-09-15 15:01:12