how to restart mysql_fetch_array while loop

[knopix]

How do you restart a while mysql_fetch_array loop?

while($row=mysql_fetch_array($result)){
     echo $row['id']."<br>"; // will echo all the IDs
}
while($row=mysql_fetch_array($result)){ // won't run at all
     echo $row['id']."<br>";
} 

[Rederick]

You could do the query again?

while($row=mysql_fetch_array($result)){
     echo $row['id']."<br>"; // will echo all the IDs
}

$result = mysql_query($query);

while($row=mysql_fetch_array($result)){ // won't run at all
     echo $row['id']."<br>";
} 

[knopix]

yeah that's the simplest way, but it wouldn't it be more efficient to restart the loop than call the mysql server?

[Rederick]

How about this: ? I've never tried it ...

 mysql_data_seek($result, 0); 

http://ca.php.net/manual/en/function...-data-seek.php

Red

[spikeZ]

You could alsways put the results from the query into a non mysql array format

$new_array = array();
while($row=mysql_fetch_array($result)){
     $new_array[] = $row['id'];
} 

Then you can use that array in any format you like

foreach($new_array as $data) {
//etc
} 

[knopix]

How about this: ? I've never tried it ...

 mysql_data_seek($result, 0); 

http://ca.php.net/manual/en/function...-data-seek.php

Red

Thank you Red, that did the trick!