note 91677 added to mysqli.multi-query

You can use prepared statements on stored procedures. You just need to flush all the subsequent result sets before closing the statement... so: $mysqli_stmt = $mysqli->prepare(....); ... bind, execute, bind, fetch ... while($mysqli->more_results()) { $mysqli->next_result(); $discard = $mysqli->store_result(); } $mysqli_stmt->close(); Hope that helps :o) ---- Server IP: 92.48.74.199 Probable Submitter: 90.212.9.102 ---- Manual Page -- http://www.php.net/manual/en/mysqli.multi-query.php Edit -- https://master.php.net/note/edit/91677 Del: integrated -- https://master.php.net/note/delete/91677/integrated Del: useless -- https://master.php.net/note/delete/91677/useless Del: bad code -- https://master.php.net/note/delete/91677/bad+code Del: spam -- https://master.php.net/note/delete/91677/spam Del: non-english -- https://master.php.net/note/delete/91677/non-english Del: in docs -- https://master.php.net/note/delete/91677/in+docs Del: other reasons-- https://master.php.net/note/delete/91677 Reject -- https://master.php.net/note/reject/91677 Search -- https://master.php.net/manage/user-notes.php