DB_result::fetchRow()
Synopsis
mixed &fetchRow (
integer $fetchmode
= DB_DEFAULT_MODE
,
integer $rownum
= null
)
Description
Returns a row of data from a result set then moves the result pointer to the next row. The data can be formatted as an array or an object.
Parameter
-
integer
$fetchmode -
the fetch mode to use. The default is DB_FETCHMODE_DEFAULT, which tells this method to use DB's current fetch mode. DB's current default fetch mode can be changed using setFetchMode(). Potential values include:
-
DB_FETCHMODE_ORDERED
-
DB_FETCHMODE_ASSOC
-
DB_FETCHMODE_OBJECT
-
-
integer
$rownum -
the row number to fetch
Return value
mixed - an array or object containing the row's data, NULL when the end of the result set is reached or a DB_Error object on failure
Note
This function can not be called statically.
Example
Using fetchRow()
<?php
// Once you have a valid DB object named $db...
$res =& $db->query('SELECT * FROM mytable');
while ($row =& $res->fetchRow()) {
// Assuming DB's default fetchmode is
// DB_FETCHMODE_ORDERED
echo $row[0] . "\n";
}
?>