the way I do something like this is write a script using PHP that does
exactly what you want, without any input or anything like that, then just
set up cron to run that script every 2 hours. you can use either lynx to hit
it as a webpage, or it's an admin script or something that you don't want
other people to be able to hit (because it'd be in the web-root) then you
can put it outside the documentroot and use the php cgi to run it.
if you use lynx, do something like this in your crontab entry (the 'timing'
might be wrong)
* 2,4,6,8,10,12 * * * lynx -source
http://yourscript > /dev/null
that will just get the source of the page, then pipe it to the 'bin' so to
speak, but in doing this, it will perform whatever operations you have told
it to in the script
// -----Original Message-----
// From: PHPFAN [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 6 July 2001 9:43 AM
// To: [EMAIL PROTECTED]
// Subject: [PHP-DB] Newbie:Backend scripts
// I am using php4 with mssql backend loaded on windows 2000.
// Here is my problem:
// I want to update my database contents every 2 hours with some sql
// Is there anyway I can write scripts in php and run them
// every 2 hours?
// Anyother solutions are most welcome.
// Thank You,
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]