Fetch next row from database query

[DrByte]

Not reliably before v155.

Why exactly are you wanting to rewind to start?

[kalastaja]

A little bit messed up - will start thinking straight after aligning with ZenCart db-procedures.

[DrByte]

The syntax is definitely much easier after upgrading to v155:

$sql = "foo";
$result = $db->Execute($sql);

foreach ($result as $row) {

  echo $row['fieldname'];

}

And also supports proper Iterator and Countable actions such as reset(), count(), as well as Move(0) and more.

... but you need at least v1.5.5 to have these available.

[kalastaja]

Ok, Thanks.

[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();
}