Running scheduled scripts that read-calculate-update MySQL tables

[baselinej]

I have a need for a table in my MySQL db to be updated using a certain formula that reads from another table in the same db. This calc needs to be run at a specified time. I am a newbie PHP hobbyist and am as dumb as SHITE....

Thanks in advance for any help that I might get.

Cheers,
Jon

[TheDefender]

Is your website being hosted on a *nix server? If so, you should be able to write a CRON job to accomplish this. If a Windows based machine, you can use the task scheduler, or run PyCRON.

[superwormy]

Indeed, Cron/Crontab is the way to go. Look it up on Google. There are various Windows crontab tutorials as well.

You're cron command might look something like this:

10 10 * /usr/local/bin/php -f /path/to/your_php_script.php

OR ( if you can't run PHP scripts with php -f )

10 10 * /usr/local/bin/lynx http://www.yoruserver.com/your_script.php