Date: 04/19/06 (PHP Community)    Keywords: php, database, sql

...and this is more of a "what's the best way to do this" question.

I have a php script that's long and complicated. Essentially it does this (in number form, because it's easier to think that way):

1. Queries an database DB1 for membership figures, based on an expiry date.
2. Counts the number of rows found.
3. For each row, the script:
   1. selects the first record from the table,
   2. stores the information in an array
   3. clears all records from a table in DB2
   4. loads the information from the array into the now-empty table in DB2.
   5. builds an email using PHPMailer using a single, never-changing email address
   6. passes the mail to a mail server for delivery. This mail server has the email address from the previous step loaded as a SQL distribution list, so it queries DB2 to get its information.
   7. Send an update query to DB1 to change the expiry date.
4. At the end of all rows, the script again empties the table in DB2, so that no data is left that could cause problems later.

Source: http://community.livejournal.com/php/441047.html