摘要:
24小时内记录(即86400秒)$sql="SELECT video_id,count(id)as n FROM `rec_down` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(add_time)<=86400 group by video_id order by n desc ";$sql="select a.id,a.title,b.n from video_info a,(".$sql.")b where a.id=b.video_id order by n desc limit 20&q 阅读全文
posted @ 2011-07-22 09:11
石头大叔
阅读(2178)
评论(0)
推荐(0)