>> I've done something very similar. I have a delivery timestamp column >> in the table that is initially NULL, and I set it to UTC_TIMESTAMP() >> for each row as I send the message. My query looks like this then: >> >> SELECT * FROM mail_queue WHERE delivery_timestamp IS NULL LIMIT 100. >> >> Andrew >> >> > Then what do you do to get the next 100 emails without sending the same > ones
Re-read the reply. After each email is sent, the timestamp is set. The original query looks for timestamp fields that are not set. -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
