(no version information, might be only in CVS)PDOStatement->nextRowset() -- Advances to the next rowset in a multi-rowset statement handle
Some database servers support stored procedures that return more than one rowset (also known as a result set). PDOStatement->nextRowset() enables you to access the second and subsequent rowsets associated with a PDOStatement object. Each rowset can have a different set of columns from the preceding rowset.
Example 1. Fetching multiple rowsets returned from a stored procedure
The following example shows how to call a stored procedure, MULTIPLE_RESULTS, that returns three rowsets. We use a do / while loop to loop over the PDOStatement->nextRowset() method, which returns false and terminates the loop when no more rowsets can be returned.
The above example will output: