Jump to content


This topic is now archived and is closed to further replies.


Top 10 in a time interval

Recommended Posts

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



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

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.