Top 10 in a time interval

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Ozz
Forum Commoner
Posts: 26
Joined: Wed Aug 21, 2002 11:47 pm

Top 10 in a time interval

Post by Ozz »

I got a mysql table like these. I wrote only necessary fields.

TABLE WEBLOG
post_id | t_stamp |month | year | day | c_hits
3 1034407262 3 2003 15 251
5 1034409443 3 2003 15 | 128
6 1034409985 3 2003 17 | 84
...


t_stamp column as unix date and also there are month,year and day columns.
My aim is to make a page shows top 10 hits on daily, weekly, monthly and

yearly base.
I want to arrange post_ids ascending in order to c_hits in a time interval.
Today's most read , this month's most read ETC..
I need mysql queries to do these.

Thanks by now
Post Reply