Daily Processing of PHP/Mysql site

[Anon]

Hello,

I have built a site using php/mysql running on Linux Red Hat 7.2.

I need a program to talk to the mysql database and send out some emails to some users automatically.

People have told me to run the process as a crontab job.
Any other possibilities for scheduling the process to run?

The process needs to read/write the MYSQL database and then send out emails.
So far I've come up with two choices
1. PHP commandline script which has mysql/mail support.
2. C program which has mysql support, but I need to write an SMTP mailer?

Does anyone see any problems/advantages with using either of the above?

Regards
Bob

[[deleted]]

I do something very similar (mail out a daily Bible reading) and I use PHP scheduled with cron to do it. Works well for me..of course I am only mailing to like 50 people, so I'm not sure how well it will scale 🙂

Matt Wade
codewalkers.com