RE: doing SELECTS and keeping the array intact with php

[Tom Crimmins]

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

This lets you set the internal row pointer of the mysql result. In your case
you would want mysql_data_seek($result,0).

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa


-----Original Message-----
From: julian haffegee
Sent: Monday, January 03, 2005 12:31 PM
To: MySQL General List
Subject: doing SELECTS and keeping the array intact with php

Hi all,

this has been bugging me for some time now.

I want to do a mysql select
then using php

while ($a_row = mysql_fetch_array($result))
  {
do something to get a small portion of the data }


and that works fine. Then later I need to access $result as a complete array
again. Is there a way I can keep $result array intact and still take a
couple values out beforehand. I can get it to work, by doing the select
twice, but thats less than ideal.

Thanks enormously if you can help

Jules