Page 1 of 1

statistics program for a site

Posted: Fri Aug 25, 2006 3:13 pm
by swisseuro
Hi there guys i come here to get some help about the design for some statistics

what i want to do is the following, get stats about certain paramters. I have a promotion going and certain people sign up for events, they can add info like who pointed them here. Now my problem is not getting these values into a DB its more how i deal with them. example

I have a click counter: now i want to make stats for that per hour so all the info is safed in the DB now after like a day should i run a script wich consolidates all that info into a new table? or into a file? or how would i go about things like that.

Other problems how can i display these stats as a diagram. please help me here a little on table design and so on.

Thanks a lot

Posted: Fri Aug 25, 2006 3:49 pm
by jabbaonthedais
Are you saying you want to track views and clicks of a link/banner? Something like that? You could write a simple one... all the data would be stored in your database (clicks per hour, etc.) and you could have a cron job add them at the end of the day and put the results in another table (so you have hourly breakdown for today, but daily breakdown for history). Check out http://phpadsnew.com/ and see if thats what you're talking about.