How to recordset more than once??

[marms]

I was wondering how to loop over a recordset more than once on that same page load.

I am using:

while ($row=mysql_fetch_array($result)) {
     //Display record
}

But when I try to use the same $result to do it again somewhere else on the page, it is either empty or returns false or something. How would I use this recordset again without going back to the database for another $result?

Thanks

[TruckStuff]

http://www.php.net/manual/en/function.mysql-data-seek.php