Пример 2. Retrieving specific rows with db2_fetch_both()
from a scrollable cursor
If your result set uses a scrollable cursor, you can call
db2_fetch_both() with a specific row number. The
following example retrieves every other row in the result set, starting
with the second row.
<?php
$sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed"; $result = db2_exec($stmt, $sql, array('cursor' => DB2_SCROLLABLE));
$i=2; while ($row = db2_fetch_both($result, $i)) { printf ("%-5d %-16s %-32s %10s\n", $row[0], $row['NAME'], $row[2], $row['WEIGHT']); $i = $i + 2; } ?>
|
Результат выполнения данного примера:
0 Pook cat 3.20
5 Rickety Ride goat 9.70
2 Smarty horse 350.00 |