Archive for the ‘MySQL’ Category

Reset a result source in PHP with mysql_data_seek

Tuesday, August 28th, 2007
  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. }

Posted in ASP, Code Examples, MySQL, PHP, typography | 5 Comments »