Hi To All,
I have a table with about 5 million records, the structure given below
Primaryid Ipaddress TimeStamp
1 127.0.0.1 2010-08-15 22:23:37
2. 18.104.22.168 2010-08-15 22:23:38
3. 22.214.171.124 2009-09-10 21:23:37
and so on.
Now i want to generate a report with
Number of hits in 2010
Number of hits in Aug 2010
Number of hits on 15 Aug 2010
Number of hits in last 1 hour
am using php to display the report.
has anyone got any idea how to do this ? if it is required , i can change the table structure & import the old data in new table structure, but i need to generate this kind of report. so if it is required , suggest with a better structure.
Thanx in advance