duplicating mysql_query result

[Ciaran]

Hi is there a way of duplicating the same mysql_query resource result
or is there a way to stop it from being cleared once it is no longer
needed? I need to run a ... while(mysql_fetch_array($result)) ... loop
twice and I want to avoid re-runnuing the query.
Cheers,
Ciarán

[=?iso-8859-1?Q?Kim_Andr=E9_Aker=F8?=]

Ciaran wrote:

Hi is there a way of duplicating the same mysql_query resource result
or is there a way to stop it from being cleared once it is no longer
needed? I need to run a ... while(mysql_fetch_array($result)) ... loop
twice and I want to avoid re-runnuing the query.

Sure thing, just use the mysql_data_seek() function between the while()
loops, like this:

while($rowdata = mysql_fetch_array($result)) {
// do something
}
mysql_data_seek($result, 0);
while($rowdata = mysql_fetch_array($result)) {
// do something entirely different
}

http://php.net/mysql_data_seek

--
Kim André Akerø
- ki******@NOSPAMbetadome.com
(remove NOSPAM to contact me directly)

[Ciaran]

On Mar 27, 3:42 pm, Kim André Akerø <[e-mail]>
wrote:

Ciaran wrote:

Hi is there a way of duplicating the same mysql_query resource result
or is there a way to stop it from being cleared once it is no longer
needed? I need to run a ... while(mysql_fetch_array($result)) ... loop
twice and I want to avoid re-runnuing the query.

Sure thing, just use the mysql_data_seek() function between the while()
loops, like this:

while($rowdata = mysql_fetch_array($result)) {
// do something}

mysql_data_seek($result, 0);
while($rowdata = mysql_fetch_array($result)) {
// do something entirely different

}

Fantastic! Thanks a lot!
Ciarán