I'm sure the convience of having the reports emailed on a specific day is
what you're looking for. But why not just code your PHP to do your
mysql_query() and mail() and place it on a webserver. Obviously have a
simple hardcoded login so just not anyone can request the reports. That way
your boss can get the goods whenever, maybe he might need them mid-month or
something comes up. He'll be able to go to the URL, enter his name and pw
and hit submit and he has them.
Not like this answered your question, just a suggestion to make it easier if
a web gateway is an option.
----- Original Message -----
From: Wojciech Milek <wojciech.milek@demo.pl>
To: Bernie Huang <bernie.huang@ec.gc.ca>; PHP_DB <php-db@lists.php.net>;
PHP_General <php-general@lists.php.net>; PGSQL-SQL
<pgsql-sql@postgresql.org>; PGSQL-GENERAL <pgsql-general@postgresql.org>
Sent: Thursday, November 30, 2000 6:16 PM
Subject: [PHP] RE: [SQL] a script that queries database periodically
> Hi!
>
> You can compile PHP without HTTP server support then you get php exec
> 'shell'
>
> and:
>
> #!/usr/local/bin/php
> <?
>
>
> echo "hello!";
>
> ?>
>
> > -----Original Message-----
> > From: pgsql-sql-owner@postgresql.org
> > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Bernie Huang
> > Sent: Monday, November 27, 2000 8:23 PM
> > To: PHP_DB; PHP_General; PGSQL-SQL; PGSQL-GENERAL
> > Subject: [SQL] a script that queries database periodically
> >
> >
> > 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
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>
>