Topic: Update a MySQL 5.0 InnoDB table column on a daily basis (Page 1 of 1)

Basically, I have a hit counter that I keep track of using an InnoDB table on a MySQL 5.0 database. The table has six fields (and a seventh field that's not relevant to this discussion): "all", "all_unique", "day", "day_unique", "month", and "month_unique". The "day" and "month" keys show the hits for the current day/month, and therefore need to be automatically cleared on a daily and monthly basis, respectively.

So my question is, how, on a MySQL 5.0 (as in, "not 5.3 and therefore not supporting events") database, do I run an UPDATE query on a daily basis? If it's not possible with just MySQL, is it possible to schedule a PHP script to run on a daily basis?

----------------------

read up on cron jobs.

Thanks for the help

----------------------