Re: [SQL] a script that queries database periodically

I have a bash script in crontab with the following line: "lynx -dump http://127.0.0.1/postgres/myPhpFile.php>${currentDir}php_output.html" You can also just put that line directly into crontab. Poul L. Christiansen Bernie Huang wrote:

Hello, My boss wants me to write a script that will send a email report to him monthly with the result of database queries. For example, an email would be like: Monthly report +----------+---------+---------------+ | Vehicles | Mileage | # of Signouts | +----------+---------+---------------+

| Vehicle1 | 10324   | 5             |

+----------+---------+---------------+

| Vehicle2 | 19384   | 6             |

+----------+---------+---------------+ ... 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? Thanks. - Bernie