Page 1 of 1

problem with mailing list

Posted: Wed Mar 11, 2009 11:57 am
by oboedrew
I could use some help brainstorming here. I'm setting up a mailing list using a flat file database. When an email address is submitted through a form, it is added to a "unconfirmed subscribers" list, and an email is sent to that address with instructions for confirmation. Once the confirmation process is complete the address is removed from the "unconfirmed subscribers" list and added to a "confirmed subscribers" list. Only then does the address actually receive messages from the mailing list.

So, here's the problem. I need to set this up so that addresses are removed from the "unconfirmed subscribers" list after x number of days, so that they don't just keep piling up. I can't think of any way to do this with php. Is this even possible?

Thanks,
Drew

Re: problem with mailing list

Posted: Wed Mar 11, 2009 12:03 pm
by Paul Arnold
You need to set up a CRON job to remove the old records.
Store the date that addresses are entered in the unconfirmed table and set the CRON job up to remove the records with a date that's older than a certain date in the past.

Re: problem with mailing list

Posted: Wed Mar 11, 2009 1:28 pm
by oboedrew
Thanks, Paul. This CRON job thing is new to me, but I just googled it and found a handful of articles, so I'll read up on it.

Cheers,
Drew