Re: mySQL Query
| From: | Gianluca Baldo | Date: | Wed, 09 Aug 2000 14:21:02 +0000 |
| Subject: | Re: mySQL Query | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-1886@lists.php.net to get a copy of this message | ||
Ralph -
RG> 1. What is the best way to do this? Do I have to write this logic in my PHP
RG> code, or can it be handled by a mySQL query.
You could simply SELECT your data from the table according to the date
you want to process.
RG> 2. Will I need to compile the cgi version of PHP so that I can run a cron
RG> job everyday?
There's no need to have PHP as CGI to run a PHP script as a cron job.
If you have PHP as a module, use lynx. You cron line will look like
(assuming you want to run the script every minute):
* * * * * lynx -dump http://www.yourdomain.com/path/to/your/script.php3
if the dir where the script
Regards,
Gianluca
--
ALBASOFTWARE
C/ Aribau 70 - 5º 1ª
08011 Barcelona (Spain)
Tel. +34 93454009 - +34 934549324
Fax. +34 934541979
@@ ICQ 47323154 @@
webmaster@albasoftware.com
http://www.albasoftware.com
http://www.phpauction.org
http://www.gianlucabaldo.com