doing SELECTS and keeping the array intact with php

2005-01-03 Thread julian haffegee
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

RE: doing SELECTS and keeping the array intact with php

2005-01-03 Thread Jay Blanchard
[snip] 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

RE: doing SELECTS and keeping the array intact with php

2005-01-03 Thread 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

Re: doing SELECTS and keeping the array intact with php

2005-01-03 Thread Peter Brawley
mysql_field_seek( resultset, 0 ); PB - julian haffegee wrote: 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

Re: doing SELECTS and keeping the array intact with php

2005-01-03 Thread Sebastian Burg
julian haffegee schrieb: 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 } hi julian, how about using this snip $result = mysql_query($sql)or