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 wrote: > On Fri, Apr 16, 2010 at 5:15 PM, Don

Re: [PHP] PHP and schedules tasks/events

2010-04-16 Thread Adam Richardson
On Fri, Apr 16, 2010 at 5:15 PM, Don Wieland wrote: > 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 lookin

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 Bastien Koert
On Fri, Apr 16, 2010 at 4:20 PM, Don Wieland 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 amount of time befor