Help with a visitor tracker I'm writing

[DaveLinger]

so here's the deal. I need a visitor tracker that will seamlessly track my number of page views and unique visitors both total and PER DAY.

So far I have the following up and working:

When someone hits my script, it checks my db table to see if their IP already has a row (each row in the table is one IP address and its info). If it does, it adds one to that row's "hits" column. If it doesn't, it adds in all of its data and makes "hits" 1. So then to get the total hits I just add all of the "hits" column values together, and to get total uniques I just count the rows.

That brings the problem of "per day", though. Couldn't I somehow tell php to every night at midnight see how many more hits/uniques there are than yesterday and save that data to a different db table? Or am I doing this all wrong?

[JasonLewis]

you could use cron. search google or phpfreaks for more info on cron jobs.