PHP Optimization: mysql_fetch_assoc vs foreach

[pcmansf]

Thank you for looking into this!

 

I need to use result from mysql query twice or more on a page

Should I do this:

$sql = mysql_query("SQL");

while ($row = mysql_fetch_assoc($sql))

    CODE

...

while ($row = mysql_fetch_assoc($sql))

    CODE2

 

OR should I keep result of a query in an array and use FOREACH instead? My concern is performance.

[bh]

If you want to stay a simple solution an array is a good choice. Another simple solution is mysqli with prepared statements.