Jump to content

Archived

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

Ozz

Top 10 in a time interval

Recommended Posts

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

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.