Hello
I have a table in the mysql database that holds date information in the following fields;
open_date
first_reminder
second_reminder
warning_flag
what I to do is, based on this date information, send an e-mail automatically to the client.
for example 3 days before the date in the open_date field, send an e-mail saying 'don't forget to give me your information'
then if the information hasn't been received, on the date in the first_reminder field, send a reminder, and so on, going through second_reminder and warning_flags unless / until the information has been received (and logged in the results table).
I have a pretty good idea about how to query the database and create the e-mails, but I have no idea about how to do this automatically, without going to the website I have created to support this database and 'pushing a button' to start this in motion. I want this to be free from human input !!
any ideas about where to start would be greatly appreciated.
TIA
