while ... loop through more than once

[jonniejoejonson]

while ($row=mysql_fetch_array($sql_result)) {

print $row['name'];

}

 

If i want to go through the result set more than once, How can i do it?...

If you try and use the above code more than once it does not work...

The only way i can see is to turn the results into arrays, and then loop through the arrays... but there must be a better way... regards J.

[Daniel0]

You have two options:

 

1) Reset the internal cursor: mysql_data_seek

2) Copy the results to an array.

 

You possibly also have a third option:

3) Refactor your code to do it in one run.

 

If at all possible, use #3.

[JAY6390]

Like Daniel0 said you should be able to refactor your code to do this. why do you need it looping more than once?