[PHP] PHP and schedules tasks/events

2010-04-16 Thread Don Wieland
Hi all, I am in need to schedule reminder emails and was wonder how to do this via PHP / mySQL For example, I would like to give my user the ability to sign-up for an event and have an email reminder generated X amount of time before the event. I appreciate any feedback on how to do

Re: [PHP] PHP and schedules tasks/events

2010-04-16 Thread Bastien Koert
On Fri, Apr 16, 2010 at 4:20 PM, Don Wieland d...@dwdataconcepts.com wrote: Hi all, I am in need to schedule reminder emails and was wonder how to do this via PHP / mySQL For example, I would like to give my user the ability to sign-up for an event and have an email reminder generated X

Re: [PHP] PHP and schedules tasks/events

2010-04-16 Thread Don Wieland
On Apr 16, 2010, at 1:26 PM, Bastien Koert wrote: Run a cronjob at midnight and send the email. Track who it got sent to, so you don't duplicate it. Easy peasy! This is fine if the email is to be sent at midnight. I am looking for more refinement. For example: A user signs up for an event

Re: [PHP] PHP and schedules tasks/events

2010-04-16 Thread Adam Richardson
On Fri, Apr 16, 2010 at 5:15 PM, Don Wieland d...@dwdataconcepts.comwrote: On Apr 16, 2010, at 1:26 PM, Bastien Koert wrote: Run a cronjob at midnight and send the email. Track who it got sent to, so you don't duplicate it. Easy peasy! This is fine if the email is to be sent at midnight.

Re: [PHP] PHP and schedules tasks/events

2010-04-16 Thread Ryan Sun
you can setup a schedule table in db and have a cron php script check the db every time and send email if the current time is around the scheduled_at time and close the schedule after you send the email On Fri, Apr 16, 2010 at 5:35 PM, Adam Richardson simples...@gmail.com wrote: On Fri, Apr 16,