I want to create a report based on 1 hr useage broken down into 5 minute increments to be displayed in a bargraph (like the one that awstats displays).
I have the fields in the database for each user,
starttime 2008-08-17 03:39:39
stoptime 2008-08-17 03:40:14
Can someone recomend a way to accomplish this with out doing 12 queries and calculating the number of users online in 5 minute increments.
How would you handle the person that was online for 2:30 within that 5 min period.
Thanks for any pointers or examples.