Reset pointer for mysql_fetch_arr ay($sth)

[Jason Carlton]

I'm needing to traverse my $sth twice:

list($date_foun d, $junk) = mysql_fetch_row ($sth);

while (list($date, $stuff1, $stuff2) = mysql_fetch_arr ay($sth)) {
// do stuff
}

But of course, when I do this then the WHILE loop starts at 1 instead
of 0 because mysql_fetch_row leaves the internal pointer at 1. I tried
reset($sth), but this just gives an error that $sth isn't an array.

Is there a way to reset the internal pointer without running a new
query?

TIA,

Jason

[Michael Fesser]

..oO(Jason Carlton)

>I'm needing to traverse my $sth twice:

list($date_fou nd, $junk) = mysql_fetch_row ($sth);

while (list($date, $stuff1, $stuff2) = mysql_fetch_arr ay($sth)) {
// do stuff
}

But of course, when I do this then the WHILE loop starts at 1 instead
of 0 because mysql_fetch_row leaves the internal pointer at 1. I tried
reset($sth), but this just gives an error that $sth isn't an array.

Is there a way to reset the internal pointer without running a new
query?

There's mysql_data_seek (), but why not simply fetch all the data into an
array first and then loop through it as often as you want? That would be
more reliable and portable.

Micha