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
Request help reporting date-time statistics
Moderator: General Moderators