note 60448 added to function.mysqli-real-query

Stored Procedures. In order to call a stored procedure that returns a result set, use mysqli_real_query. Here is a short example: $mysqli = new mysqli(DBURI,DBUSER,DBPASS,DBNAME); if (mysqli_connect_errno()) { printf("Connection failed: %s\n", mysqli_connect_error()); exit(); } $SQL = "CALL my_procedure($something)"; if (!$mysqli->real_query($SQL)) { printf("Invalid query: %s\nWhole query: %s\n", $mysqli->error, $SQL); exit(); } if ($result = $mysqli->store_result()) { while ($myrow = $result->fetch_array(MYSQLI_ASSOC)) { $aValue[]=$myrow["a"]; $bValue[]=$myrow["b"]; } $result->close(); } $mysqli->close(); I hope this saves someone some time. ---- Manual Page -- http://www.php.net/manual/en/function.mysqli-real-query.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+60448 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+60448&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+60448&report=yes Search -- http://master.php.net/manage/user-notes.php