Re: [GENERAL] Re: [PHP] a script that queries database periodically

Jason's definitiely on the right track. I'd add that if you don'tknow Perl, Python might be easier. Check http://sourceforge.net/forum/forum.php?forum_id=39069, starship.net might also have a PostreSQL module. Python also has a very easy to use SMTP module for mailing of reports. There's nothing anti-Perl here, I just don't know that language and found Python quite natural. Miles Thompson RE Jason wrote: > > 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? > > if you know perl, you should check out DBI. Read all about it at > www.cpan.org. It's pretty similar to the php database interface.