I'm not sure if PHP can really do what I want here. Maybe SQL can.. Not sure really what I need. Here is the scenario.
I get email address/etc from page and use PHP to put it in SQL database. This database holds the email addresses of everyone on the mailing list. Now in another database I use to display a page that changes daily. I've written the code that allows such pages to be queued up and only displayed on the day they should be.
Now the mailing list is for people who don't want to come daily, but would rather have it emailed to them. I know PHP has a mail() function or some such, but the ways I can think about using it would require a webmaster to press some kind of Send Page to Mailing List button once a day.
I'd much perfer if this was autmatic. So that it takes the page for the day and sends it out every day at the same time.
I don't think PHP has any mechanism for doing this since its merely a hypertext preprocesor. When I looked around in mySQL I noticed it had something called processes. Altho I don't know anything at all about them.
So what I'd like to know is what method is usually used for an autmoatic email system? I'm using globat.com for hosting, they provide quite a few services, but I don't think I want to have to have them install a special program for doing this.
Anyway just wanted to know what my options are, thanks.
