Automated Appointment Reminder

Question

I need to create a web application using php, I had many users having appointments on different days and time. What I need is to send emails say 1 day, 6 hours and 1 hour before their respective appointments, cron job seems to be the option but how to run script at the specific times(when email has to be sent) for every user?

Answer 1

You would create a script that determines if any emails need to be sent, then call that from cron every hour (or minute or whatever).