newbie-reset in database

[Anon]

hi

I have a database which tracks how many hits a website has sent me. I wanna
write a script to reset this particular field so that it will be zero at
12:00 in the morning. How do i do it? Any suggestion would be appreciated.

my database is kinda like this(mysql

url | hits

http://www.yahoo.com | 100

Thank You!

[spider_man]

That's an easy job if you have any priviledges to use Unix's cron function