How can I loop through a MySQL result set more than once using the mysql_* functions?

by

This is how you can do it:

$result = mysql_query(/* Your query */);
while($row = mysql_fetch_assoc($result)){
 // do whatever here...
}

// set the pointer back to the beginning
mysql_data_seek($result, 0);
while($row = mysql_fetch_assoc($result)){
 // do whatever here...
}

However, I would have to say, this doesn’t seem the right way to handle this. Why not do the processing within the first loop?

More Related Contents:

  1. php+mysql Fatal error: Call to undefined function mysql_connect()
  2. Using PHP data in MySQL [closed]
  3. drop down menu using php and mysql [closed]
  4. php code for multiple search box after connecting to mysql [closed]
  5. Checking the availability of rooms
  6. How to sort user data by id
  7. mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource
  8. Using PHP 5.5’s password_hash and password_verify function
  9. Example of how to use bind_result vs get_result
  10. mysqli::query(): Couldn’t fetch mysqli
  11. I have an array of integers, how do I use each one in a mysql query (in php)? [duplicate]
  12. Levenshtein: MySQL + PHP
  13. Incorrect Integer (2147483647) is inserted into MySQL?
  14. PHP date() format when inserting into datetime in MySQL
  15. convert php date to mysql format
  16. Special characters in PHP / MySQL
  17. Fetching single row, single column with PDO
  18. IP address storing in MySQL database using PHP [duplicate]
  19. “No such file or directory” or “No such host is known” when running migrations
  20. Password_Hash not working on my PHP login
  21. Select last 20 order by ascending – PHP/MySQL
  22. Formatting an SQL timestamp with PHP
  23. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  24. How to backup MySQL database in PHP?
  25. Auto Increment skipping numbers?
  26. PDO bindParam into one statement?
  27. Convert Time String to Decimal Hours PHP [closed]
  28. Is mysql_real_escape_string enough to Anti SQL Injection?
  29. How to make mysqli connect function?
  30. Using PHP to upload file and add the path to MySQL database

Leave a Comment