Ozz Posted June 15, 2003 Share Posted June 15, 2003 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 Link to comment https://forums.phpfreaks.com/topic/597-top-10-in-a-time-interval/ Share on other sites More sharing options...
shivabharat Posted June 19, 2003 Share Posted June 19, 2003 Try this select * from weblog order by c_hits desc limit 1,10 Link to comment https://forums.phpfreaks.com/topic/597-top-10-in-a-time-interval/#findComment-2036 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.