SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limi">
帝国教程

sql调用点击排行和顶排行可指定栏目ID

来源:帝国CMS模板网 作者:争端 时间:2026-07-08
浏览:23 收藏 点赞(0)
简介:[ecmsinfo]"select * from phome_4ecms_news where checked=1 order by diggtop desc,id desc limit 10",10,30,0,24,10,0[/ecmsinfo] 这个是顶的排行 [ecmsinfo]"select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limi
[ecmsinfo]"select * from phome_4ecms_news where checked=1 order by diggtop desc,id desc limit 10",10,30,0,24,10,0[/ecmsinfo]

这个是顶的排行

[ecmsinfo]"select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limit 10",10,30,0,24,10,0[/ecmsinfo]

这个是7天点击的排行。

那怎么按照按栏目来显示呢,以下方法就是

select * from phome_4ecms_news where newspath >SUBDATE(NOW(),INTERVAL 7 DAY) and classid=栏目id order by onclick desc limit 10
在线
客服