Page 1 of 1

Request help reporting date-time statistics

Posted: Mon Feb 21, 2011 10:05 pm
by fpearl
Hi there,

I am working on an app that reports date and time statistics. A mysql table stores each login with a unix timestamp. Setting aside the question of timezones (which I think I can handle), I want to get the following statistics in an expedient fashion:

number of logins today
number of logins this week
number of logins this month
average number of logins per day
a list of the last 25 visitors

I know how to query for each of the above statistics. What I am trying to do is accomplish it without making 3 or 5 queries. Is there a more efficient way?

Fred