Re: limiting the amount of emails sent at a time in a batch send

>> 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/