need to clear a mysql field every.. night but how?

[thewomb]

i need to get some info ( if its posible ) to write a script that will purge a Mysql row every night at a specific time and reset it to '0'

any ideas guys?

thanx

[OhLordy]

What operating system is your webserver running on?

[thewomb]

Linux

[OhLordy]

You can use crontab then
do
man crontab
at the command line to get more info on this cron

Then all you have to do is write a script to do what you want and set it up to run from the command line
ie
add a line into your crontab with the time bit and then php -q [path_to_file]
HTH
Rob