Soldato
Hi,
I've been set the task of creating a simple reminder system (where the user can specify a date and time) using php and mysql, but could do with some opinions. I have a simple reminders table:
ID, reminderText, date, userID, status (when reminder has been sent update staus).
I'm having a bit of trouble with my logic though
I was thinking of setting up a cron job to run every 15 mins (E.g. at 1:15, 1:30 etc.) to select:
Thanks
I've been set the task of creating a simple reminder system (where the user can specify a date and time) using php and mysql, but could do with some opinions. I have a simple reminders table:
ID, reminderText, date, userID, status (when reminder has been sent update staus).
I'm having a bit of trouble with my logic though
I was thinking of setting up a cron job to run every 15 mins (E.g. at 1:15, 1:30 etc.) to select:
- status = 0 (no sent)
- reminder date equals todays date
- the reminder time is 30 mins before current time
Thanks