multiple mysql_fetch_array() calls

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

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

$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?.


Re: multiple mysql_fetch_array() calls

You can also use this:

mysql_data_seek ($result, 0);

Re: multiple mysql_fetch_array() calls

Dave Moore wrote:
Quoted text here. Click to load it
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.

Site Timeline