Leading zeros - the easy way »

Reset a result source in PHP with mysql_data_seek

  1. $result = mysql_query("SELECT names FROM table;");          
  2.  
  3. while($row=mysql_fetch_array($result,MYSQL_ASSOC)) {
  4.  
  5.           //procedure
  6. }
  7.  
  8. mysql_data_seek($result,0); // Reuse your recordset
  9.  
  10. while($row=mysql_fetch_array($result,MYSQL_ASSOC)) {
  11.  
  12.         //procedure
  13.  
  14. }

This entry was posted on Tuesday, August 28th, 2007 at 10:41 pm and is filed under ASP, Code Examples, MySQL, PHP, typography. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

5 Responses to “Reset a result source in PHP with mysql_data_seek”

  1. cherly Says:
    September 15th, 2007 at 10:19 am

    Thanks for the special work and information!

  2. Wahoo Says:
    October 6th, 2007 at 6:14 pm

    Thank you for sharing!

  3. Erik Says:
    February 4th, 2009 at 7:42 am

    looks to me that $row would be the same everytime.
    what’s the point of the first ‘while’ then? why not just use a join?

    please, what am i missing? thanks

  4. admin Says:
    February 4th, 2009 at 8:29 am

    Erik, good catch! thanks!

  5. Matt Says:
    February 25th, 2009 at 4:48 pm

    Thank you! That saved me about 10 db queries in a script!

Leave a Reply

watch free movies online download movies online free movies online