Received: from aua2.aua.auc.dk (aua2.aua.auc.dk [130.225.54.5]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eARLiJt78378 for ; Mon, 27 Nov 2000 16:44:19 -0500 (EST) (envelope-from poulc@cs.auc.dk) Received: from obel.auc.dk (cw.obel.auc.dk [192.168.64.3]) by aua.auc.dk (PMDF V5.2-32 #30369) with SMTP id <01JX1UZZQ94696VTJE@aua.auc.dk> for pgsql-general@postgresql.org; Mon, 27 Nov 2000 22:44:24 MET Received: (qmail 13741 invoked from network); Mon, 27 Nov 2000 21:40:49 +0000 Received: from plc.obel.auc.dk (HELO cs.auc.dk) (192.168.64.31) by cw.obel.auc.dk with SMTP; Mon, 27 Nov 2000 21:40:49 +0000 Date: Mon, 27 Nov 2000 22:44:39 +0100 From: "Poul L. Christiansen" Subject: Re: [SQL] a script that queries database periodically To: Bernie Huang Cc: PHP_DB , PHP_General , PGSQL-SQL , PGSQL-GENERAL Message-id: <3A22D5C7.2030502@cs.auc.dk> MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-15; format=flowed Content-transfer-encoding: 7bit User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; m18) Gecko/20001108 Netscape6/6.0 X-Accept-Language: en References: <3A22B485.E8963417@ec.gc.ca> X-Archive-Number: 200011/860 X-Sequence-Number: 992 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 >