Automatic update

[Anon]

I want a database to be updated once each hour. It's for a message board and I have a script for cleaning out bogus messages. I need to autorun the script each hour. How can I do that? Can I make some kind of loop?

[Anon]

You can use a chrontab entry and setup php as a shell scripting language -- or make some sort of auto clean up inside the code itslef using some random number stuff you can tell it whether or not to delete old messages and the what not, that i smy current implentation for old sessions in my databse setup at random my code will preform variuos garbage clean up on the database works and it only slows down the load time on one user anbd depending on how you setup the randomnes (spelling) and current user load you cna set this sytem up to clean up whenever you want it to -Jon

[Anon]

Hi,

Crontabbing is the solution I use. While your script is cleaning out the database, it could also dump it using mysqldump, gzip it and send it away so you have an off-site backup.

PHP as a shell-scripting language was described in www.phpbuilder.com/columns/darrell20000319.php3

Johan

[Anon]

Like Jon said you should use Crontabs. You must create a crontab file (simple text file with a few lines of commands) with lists of things to do. The last time I did this was a while ago so I can't quite remember the syntax. Ask you web host.

Billy

[Anon]

9 wget -q -O /home/cron_hour.out http://yoursite.com/scipts/cron_hour.html

will run each 9th minutte of hour.
range: 0-59