On Wednesday 18 February 2009 19:32:53 Michael Orlitzky wrote:
> I won't make any claims as to the correctness or efficiency of this > approach, but one way that I've seen this done is to store a record in > the database immediately, and then have a (cron) PHP script running > every 5 minutes or so to process any "ripe" messages. > > The script would execute the following pseudo-SQL, "SELECT * FROM > pending_messages WHERE subscription_level=cheap_bastard AND (now - > time_submitted) >= 2 hours". You would then loop through the results, > sending them off to mail() or whatever one at a time. At the risk of going too much off-topic, this is a valid solution if the app stores the data it's going to mail and you can get support for the feature upstream or it's you own app. Otherwise it's going to be a administrative nightmare. -- Melvyn Sopacua
