note 69503 modified in mysqli.multi-query by danbrown
| From: | danbrown@php.net | Date: | Fri, 28 Nov 2008 22:54:51 +0000 |
| Subject: | note 69503 modified in mysqli.multi-query by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-147395@lists.php.net to get a copy of this message | ||
Ive just had exactly the same problem as below trying to execute multiple stored procedures. I
thought i might as well add how to do it the object oriented way.
Instead of putting the one statement:
<?php
$mysqli->next_result();
?>
Put two:
<?php
$mysqli->next_result();
$mysqli->next_result();
?>
The first statement points (possibly using the term incorrectly) you to the return value. The second
one will point you to the result of the next query.
I hope this makes sense.
--was--
Ive just had exactly the same problem as below trying to execute multiple stored procedures. I
thought i might as well add how to do it the object oriented way.
Instead of putting the one statement:
$mysqli->next_result();
Put two:
$mysqli->next_result();
$mysqli->next_result();
The first statement points (possibly using the term incorrectly) you to the return value. The second
one will point you to the result of the next query.
I hope this makes sense.
http://php.net/manual/en/mysqli.multi-query.php