Automatic mailing list on Linux server...

[fabiuz]

Hi,

I have made a little mailing list software with PHP and MySQL, it is working very well ...I am using it directly to compile and send mailings trought a form...

Now I am asking myself if it is possible to let it work automatically by sending mails, every day at a fixed time eg. every day at 6 am it should take a random record from a DB and send a mail to all the users listed in the e-mails table...

Anybody here could tell me if it is possible using PHP and a Apache server based on Linux ? If yes how ?

Thank you very much for any help about!

Fabi

[dannys]

The best way would be to setup a cronjob to run the PHP script at a certain time interval.

Google search for CronJobs for more info.

[gowni]

u can use the cron job like this

login to the linux
using u r username and password
type crontab -e
it will open a vi editor
type the following
and close the file

00 06 * /usr/local/bin/php public_html/crontest.php

it will run the script at 6 am daily

the first parameter is the path of php interpreter and the next is the path of php file

hope this may help u.