RE: [PHP] a script that queries database periodically

> I was thinking of writing up a PHP script and put into > crontab, which is > somehow easier than a shell script, but PHP is an apache module, so I > cannot execute PHP under crontab (it has to be executed in a browser > right?). I guess a shell script is necessary. So, is it possible to > call 'psql' and returning its query result and I can use sendmail to > email the result? Any other idea? Make the php script and put it in the web directory, then in your crontab use wget to fetch the page. e.g. /usr/bin/wget -q -O /dev/null -nd http://some.host/your/php.script Layne Weathers Ifworld, Inc. layne@ifworld.com