Request help reporting date-time statistics
Posted: Mon Feb 21, 2011 10:05 pm
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
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