user twice of one mysql_query

[alirezaok]

i have

$query = mysql_query("SELECT * FROM `test` WHERE `user_id` =$id"); 
while ($row1 = @mysql_fetch_array($query)) 
{
/////some echo codes
}

while ($row2 = @mysql_fetch_array($query)) 
{
/////some echo codes
}

but second "while" doesn't work. i forced to define another $query same as first $query and used it in second while.

is there any way to use only one $query define to use in 2 while?

thanks

[thorpe]

You could use [man]msql_data_seek[/man] to return your result set back to the start.

[m_tt]

Just run fetch_array once and store the results.

$query = mysql_query("SELECT * FROM `test` WHERE `user_id` = '{$id}'");
$result = mysql_fetch_array($query);

foreach($result as $row1)	{
}

foreach($result as $row2)	{
}