帝国cms自定义信息列表显示本月内容和其它热门等
时间:11-26 分类：电脑网络
帝国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
指定栏目：问：能否指定栏目调用呢？
[ecmsinfo]"select * from phome_ecms_news where newstime > UNIX_TIMESTAMP()-86400*30 AND classid in('2','3') order by onclick desc limit 10",10,30,0,24,7,0[/ecmsinfo]
- 相关文章
- 推荐文章