The function move() moves the cursor to the n^th record in a recordset. Offsets are zero-based.

If the cursor is successfully moved then the function returns true. If the move is unsuccessful (negative offset, passed EOF, etc), the function returns false.

Note that some databases do not support moving to previous rows (scrolling backwards).

/*
 * Connection to DB2 sample database
 */
$sql = "SELECT * FROM act";
$recordset = $db->execute($sql);
 
/*
 * Go to the 10th record
 */
$recordset->move(9);
 
/*
 * Retrieve the record as an object
 */
$record = $recordset->fetchObj();
 
print_r($record);
/*
 * Prints
ADOFetchObj Object
(
    [ACTNO] => 100
    [ACTKWD] => TEACH
    [ACTDESC] => TEACH CLASSES
)
*/