I'm an aspiring PHP developer doing some side jobs just for fun and I was wondering if someone can help me out with this.
I'm working on a project now which stores $_POST information into a separate table called 'stats'. I'm trying to create an 'admin backend' for my user so they can see how many people had used their service, as well as some calculated figures which I've managed to store into the database.
Now what I'm wondering is, how would I go about separating all of this data by the day so they can do a comparison by the days, weeks, months, years etc.
For example, if they wanted to see how many users used their service on August 12, 2010, how would I create 'filters' so they can see that date as well as if they were looking for, how many users thought the service was helpful in the month of August?
Would I need to create a timestamp as a field? What type?
Thanks for your advice and assistance in advance experts!