Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eB44mBF63010 for ; Sun, 3 Dec 2000 23:48:11 -0500 (EST) (envelope-from pgsql-general-owner@postgresql.org) Received: from serv1.ilse.nl (serv1.ilse.nl [212.189.131.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eARN6ot82592; Mon, 27 Nov 2000 18:06:50 -0500 (EST) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv1.ilse.nl (8.11.0/8.10.2) id eARN6QP60894; Tue, 28 Nov 2000 00:06:26 +0100 (MET) Date: Tue, 28 Nov 2000 00:06:26 +0100 From: Mathijs Brands To: "Poul L. Christiansen" Cc: Bernie Huang , PHP_DB , PHP_General , PGSQL-SQL , PGSQL-GENERAL Subject: Re: [SQL] a script that queries database periodically Message-ID: <20001128000625.B60768@ilse.nl> References: <3A22B485.E8963417@ec.gc.ca> <3A22D5C7.2030502@cs.auc.dk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3A22D5C7.2030502@cs.auc.dk>; from poulc@cs.auc.dk on Mon, Nov 27, 2000 at 10:44:39PM +0100 X-Unexpected-Header: The Spanish Inquisition X-Archive-Number: 200012/62 X-Sequence-Number: 1242 On Mon, Nov 27, 2000 at 10:44:39PM +0100, Poul L. Christiansen allegedly wrote: > 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 Be sure to redirect the output of the command in your crontab to /dev/null or something similar. If you don't, the output (HTML) will be emailed to you each time the script is run. Whether this side effect is desirable is of course up to you (or your boss, for instance). Getting even more off-topic, Mathijs -- "Where is human nature so weak as in a bookstore!" Henry Ward Beecher (1813-1887)