Re: [PHP-DB] Automated Processes From: Jamie Alessio (alessio <email protected>)
Date: 11/20/00

> My question i guess is how to get the automated reminder process to happen.
>
Your best bet (if you're using *nix) is to set up a cron job that either runs a PHP or
Perl script at a specified time. If you want to use a PHP script then you'll have to
compile PHP as a CGI executable. Admittedly, I was a bit hesitant to do this for a while
because I thought it would be a headache but it turned out to be extremely simply and it's
great to be able to run PHP scripts from the command line and pipe data to it. The second
option is to use Perl which is most likely already installed on your system but you'll
probably have to install DBI to get it to talk to your database. The disadvantage to this
is that you have to develop some things in Perl and some in PHP so I'd recommend trying
out compiling PHP as a CGI executable.

Whichever one you choose just set up and cron job that calls a script that queries the DB
and sends emails out. More info on setting up a cron job can be found a linuxdoc.org. Hope
that helps.

- Jamie 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>