note 52848 added to function.mysql-fetch-assoc

When you have to loop multiple times through the result of a query you can set the result pointer to 0 (zero) with mysql_data_seek () The advantage is that you do not have to query database twice with te same query :) So: <?php $query = " SELECT * FROM database "; //Query database $result = mysql_query ($query); //Iterate result while ($record = mysql_fetch_assoc ($result)){ print_r ($record); } ... //Point to 0 (zero) mysql_data_seek ($result, 0); //Re-use the result while ($record = mysql_fetch_assoc ($result)){ print_r ($record); } ?> ---- Manual Page -- http://www.php.net/manual/en/function.mysql-fetch-assoc.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+52848 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+52848&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+52848&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+52848&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+52848&report=yes&reason=useless Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+52848&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+52848&report=yes Search -- http://master.php.net/manage/user-notes.php