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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]