摘要: 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 石头大叔 阅读(2173) 评论(0) 推荐(0) 编辑