multiple mysql_fetch_array() calls

Hi All,
I've got a simple query hopefully somebody can clear up for me. I need to
make a query on a database to select a set of table rows, using something
like:

$result = mysql_query($query);

I can then use mysql_fetch_array in a while loop to access each row in the
result. This all works fine.

However, what I'd like to do is to go through this result more than once.
ie. use mysql_fetch_array() to go through each row in $result more than
once. How do I do this?. There appears to be no my of resetting
mysql_fetch_array back to the beginning of the $result once all rows have
been erad once.

I don't want to make multiple identical queries on the database, simply to
read the same information.

Any ideas?.

Ta,
Dave

Dave Moore wrote:
> Hi All,
> I've got a simple query hopefully somebody can clear up for me. I need to
> make a query on a database to select a set of table rows, using something
> like:
>
> $result = mysql_query($query);
>
> I can then use mysql_fetch_array in a while loop to access each row in the
> result. This all works fine.
>
> However, what I'd like to do is to go through this result more than once.
> ie. use mysql_fetch_array() to go through each row in $result more than
> once. How do I do this?. There appears to be no my of resetting
> mysql_fetch_array back to the beginning of the $result once all rows have
> been erad once.
>
> I don't want to make multiple identical queries on the database, simply to
> read the same information.
>
> Any ideas?.
>
> Ta,
> Dave
>
>
Store your first time result in your own query.. and then just loop your
own query as many times as needed...

$yourArray = array();
while($row = mysql_fetch_array($result, MYSQL_ASSOC) {
$yourArray[] = $row;
}

then just do this as many times as needed...

foreach($yourArray as $rowNum => $row) {
//$row would be same as the original $row inside the while loop
inside this loop.
}

You can also use this:

mysql_data_seek ($result, 0);


http://us4.php.net/manual/en/functio...-data-seek.php