参考(一周内评论最多的5条新闻):
select commentnews.news_id,news.news_title,count(commentnews.news_id)as num from commentnews,news where commentnews.news_id=news.news_id and commentnews.comment_time>SUBDATE(NOW(),INTERVAL 7 DAY) group by commentnews.news_id order by num desc limit 0,5
一周最新的php代码
最新推荐文章于 2021-03-10 16:48:21 发布