Automatically send email based on SQL database?

[BG4533]

I recently created an online scheduling web site to schedule experiments for a psychology project I am doing. The website is created using PHP and mySQL and is running on a Redhat server. I would like to be able to automatically send out a reminder email say 24 hours before a persons experiment. Any ideas or suggestions on how to do this? I figure I need some other program or something to do this, but I have no idea how.

Thanks,
Brian

 

[Barnaby W. Füi]

Make a cron job that runs a script once a day. The script can check the database and send the appropriate emails.

 

[BG4533]

Thank you. Looks like my server lets me do that. Now to figure out how...

 

[jonmullen]

yah even if you dont know Perl or anybetter scripting lang than PHP IIRC the PHP now has a command line utility so you dont have to learn another lang.