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
Top 10 in a time interval
Moderator: General Moderators