Fetch next row from database query

[lat9]

Not reliably before v155.

Why exactly are you wanting to rewind to start?

Really? I've been using the following construct for a couple of years now to "rewind" a previously-processed query back to the beginning:

$result = $db->Execute (<some sql query>);
while (!$result->EOF) {
    ...
    $result->MoveNext ();
}
...
// -----
// "Rewind" the query to re-process ...
//
$result->Move (0);
$result->MoveNext ();
while (!$result->EOF) {
    ...
    $result->MoveNext ();
}

[mc12345678]

As suggested here, "reliability" (backwards compatibility to before ZC 1.5.5) can be obtained by testing for the method rewind as suggested by DrByte:

$result->Move(0);
if (!method_exists($result, 'rewind')) {
  $result->MoveNext();
}