作者/整理:锦皓工作室 时间: 2017-07-31 浏览:
区别:
自定义列表: 使用普通列表模板,不能使用列表模板中的一些调用参数。
列表模板 : 普通列表页面使用的模板,可以使用列表模板中的一些参数。
如要列表要正常分页,必须要使用:
[!--empirenews.listtemp--]
<!--list.var1-->
[!--empirenews.listtemp--]
SQL语句:
----------------------------------------------------
热门信息列表
统计记录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
指定id信息列表
统计记录:select count(*) as total from [!db.pre!]ecms_news where classid=14
查询记录:select * from [!db.pre!]ecms_news where classid=14 order by id desc