multiple mysql_fetch_array() calls

[Dave Moore]

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

[Paul]

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.
}

[Steve]

You can also use this:

mysql_data_seek ($result, 0);
http://us4.php.net/manual/en/functio...-data-seek.php