I am now using a birthday form script so that everyone who fills out my questionnaire gets added to a mysql database and when it is their birthday, gets sent a birthday greeting. Also, when they fill out my questionnaire, based on a number of factors they get a personalized autoresponse from the same php script that processes the form. I would like them to get a delayed response instead of maybe 2 hours or so. In addition I would like them to receive another email 8 hours in, and maybe another two days later for example, etc. The code currently consists of two php files 1) Accepts data, checks it, uploads to database and sends an autoresonse to me and my visitor. 2) Cron php file that starts every day to check for user birthdays in the database or for special events like the new year and sends them an email. I guess this would probably involve running the cron job every hour and having flags set in the database if the birthday email or autoresponder email has already been sent out or something. if not the send out the appropriate email from an HTML template again. I would like the delayed autoresponder to have the flexibility to send out a customized email based on either template HTML files like it does currently, or generated and stored in php form 1 like it does now based on their form input. If requested I can provide the current source for a bid offer.
Updated php files and maybe a new file or two. Note: I need this done as soon as possible.