Page 1 of 1

E-mail documents page design

Posted: Tue Nov 08, 2005 1:28 pm
by bubberz
I'm new to PHP, and am assigned a project to allow users to click checkboxes for which documents they want e-mailed to them monthly.

There are five documents they can choose from, and I was thinking the database would be 6 columns:
1. E-mail address as PK
2. 5 other columns representing the 5 documents as a bit type

What I don't know is how to start with getting a SPROC on mySQL for scheduled e-mailing, or if this is even available.

We've chosen a hosting site, so I'm wondering if there's anything I need to check with them first to see if this is possible.

Any suggestions are welcome!

Posted: Tue Nov 08, 2005 1:38 pm
by s.dot
for scheduled processes, you'll want to have a look at running a cron job.

cron job?

Posted: Tue Nov 08, 2005 1:46 pm
by bubberz
Thanks scrotaye!

What's a cron job?

Posted: Tue Nov 08, 2005 1:50 pm
by s.dot
a program that will run a specified script at specified time intervals without your interaction

Posted: Tue Nov 08, 2005 1:51 pm
by bubberz
Great..thanks!

I'll look into it!