another while after a while over recordset

[buducom]

i have
while($i=mysql_fetch_array($selectgroups)) {
}

i guess he is putting the pointer on the recordset until
the last record
how can i put the pointer back
so i can make another while on the same recordset on the same page without having to make another select from mysql?

[tuf-web_co_uk]

have you triedjust doing the same again

while($i=mysql_fetch_array($selectgroups)) { 
} 

// some other code

while($i=mysql_fetch_array($selectgroups)) { 
} 

[buducom]

yes i did and it didnt work.
should it?

[Weedpacket]

No, it shouldn't. The record set is exhausted by the first loop. You'll need to refresh it before looping again. Looking at the function list, there doesn't seem to be anything that could be used.

But if I'm going to be using something more than once I prefer to put it in a variable (an array in this case) and get it from there when I need it. Faster.

$result_array= array();
while($row=mysql_fetch_array($result))
{ $result_array[] = $row;
}

And then loop through $result_array instead.

foreach($result_array as $i)
{ // use $i[] the same way as you were
}

[ahundiak]

mysql_data_seek($selectgroups,0);
http://www.php.net/manual/en/function.mysql-data-seek.php