daily stats

[Anon]

I'm writing something for an advertising script and was wondering, what is the easiest way to setup a table for daily stats..

like.. theres one way, where every new publisher gets another column...

or.. how else?

[[deleted]]

Create a table like this:

hitid, publisher, date, referer, remoteip

then store every hit in the same table with the correct data in it.

Later you can process the data and get the stats.

read about GROUP BY in the MySQL manual.