Topic awaiting preservation: Tools that sends out email after finding items that matches the criteri

Any one knows of any tools that could be used in a Course registration process. i.e. once a user registered himself into database, a confirmation email will be sent out. and in 1 months (or other set date) time send out a reminder.

If there is no existing package. Any idea how this could be achieve?

Thank you so much.

How you go about it is pretty easy. A few php scripts tying into a SQL database for your user registration and other database information should do the trick, and a cron job (assuming *nix) set to run 30 days from the registration date.

How you do it is easy. Actually doing it is a bitch and a half. Not to mention a million coding details and access to a php/SQL/SSI *nix server for hosting.

Just a note on a process, for something like this as opposed to a cronjob set up for 30 days after posting, I'd a run a once a day job that queried the db to find out who had registered 30 days ago and send confirmation emails one at a time.

Actually if you already have the registration process set up then writing the script to send the 30 day emails is relatively easy.



.:[ Never resist a perfect moment ]:.

Pimms One: You didn't speciy the language you are using - in PHP you'd just use mail(). Kuckus has done a great tutorial on this function and the 'you have been registered' email is really only just an extension of this:
http://development.gurusnetwork.com/tutorial/contact_page/

___________________
Emps

FAQs: Emperor

Sorry. I am thinking of using Java and mySQL. What option do I have? Thank you.