Hello, I searched through the forum and couldn't find anything like what I need to do. This is for a site that has music shows on it so everytime a show is happening that day I want it to send an e-mail with a link to that show in it from the e-mail addresses I have in a db. But I have no idea how to have a script that isn't drive by a form send these e-mails. Thanks in Advance.
By using the [man]mail[/man] function...
You can query the DB, and then run a loop through your results to output specifically what you want. Which part do you not know how to do?
You can write a CRON job to fully automate the process.
How do I set up the CRON to have it execute everyday at 12:01 am
A lot of hosts use cpanel, and there's a module to setup CRON jobs using a beginner or advanced interface. You'd probably need to consult with them on how to specifically setup a CRON job to run a php script... I could tell you how I'd do it on my host, but it could very well be different for your particular setup.