帝国cms列表写php,帝国cms自定义信息列表显示本月内容和其它热门等

帝国cms自定义信息列表显示本月内容在cms自定义信息列表里加上以下内容

统计记录: select count(*) as total from phome_ecms_news where newstime>UNIX_TIMESTAMP()-86400*30

查询记录: select * from phome_ecms_news where newstime>UNIX_TIMESTAMP()-86400*30 order by onclick desc

如图

热门信息列表

统计记录select count(*) as total from [!db.pre!]ecms_news where checked=1 order by onclick desc

查询记录select * from [!db.pre!]ecms_news where checked=1 order by onclick desc

推荐信息列表

统计记录select count(*) as total from [!db.pre!]ecms_news where checked=1 and isgood=1 order by newstime desc

查询记录select * from [!db.pre!]ecms_news where checked=1 and isgood=1 order by newstime desc

统计记录select count(*) as total from [!db.pre!]ecms_news where checked=1 and firsttitle=1 order by newstime desc

查询记录select * from [!db.pre!]ecms_news where checked=1 and firsttitle=1 order by newstime desc

最新的语句不知道怎么写

呵呵,终于自己找到喇

全站按最新的排行调用语句

统计记录select count(*) as total from [!db.pre!]ecms_news where checked=1 order  by  newstime  desc

查询记录select * from [!db.pre!]ecms_news where checked=1 order by newstime desc

前十条最新的

根据最新文章 select * from [!db.pre!]ecms_news where checked=1 order by newstime desc limit 10

统计一个地区的列表

统计记录：select count(*) as total from [!db.pre!]ecms_flxx where checked=1 and classid=7

查询记录：select * from [!db.pre!]ecms_flxx where checked=1 and jtdq like "%温州%" order by id desc