YouTip

# PDOStatement::nextRowset [PHP PDO Reference](#) PDOStatement::nextRowset — Advance to the next rowset in a multi-rowset statement handle (PHP 5 >= 5.1.0, PECL pdo >= 0.2.0) * * * ## Description ### Syntax bool PDOStatement::nextRowset ( void ) Some database services support stored procedures that return more than one rowset (also known as result sets). PDOStatement::nextRowset() allows you to access the second and subsequent rowsets associated with a PDOStatement object. Each of the rowsets can have a different set of columns. * * * ## Return Values Returns TRUE on success, or FALSE on failure. * * * ## Examples ### Fetching multiple rowsets returned by a stored procedure The following example demonstrates how to call a stored procedure that returns three rowsets using MULTIPLE_ROWSETS. A do / while loop is used to iterate through the calls to PDOStatement::nextRowset(), which returns false when there are no more rowsets and ends the loop. query($sql); $i = 1;do { $rowset = $stmt->fetchAll(PDO::FETCH_NUM); if ($rowset) { printResultSet($rowset, $i); } $i++;} while ($stmt->nextRowset());function printResultSet(&$rowset, $i) { print "Result set $i:n"; foreach ($rowset as $row) { foreach ($row as $col) { print $col . "t"; } print "n"; } print "n";}?> The above example will output: Result set 1: apple red banana yellow Result set 2: orange orange 150 banana yellow 175Result set 3: lime green apple red banana yellow * * PHP PDO Reference](#)