用灵动标签调用最新最多评论文章:[e:loop={'select * from [!db.pre!]ecms_news where checked=1 order by plnum desc,id desc limit 8',10,24,0}]
<li> <small><a href="<?=$bqsr[titleurl]?>" class="title"><?=su……
帝国CMS任意模板中调用留言,可只调用已审核的留言,也可不限制是否审核。代码如下:<?
//bid为留言分类ID,checked='0' 0为已审核,1为未审核
$sql=$empire->query("select * from {$dbtbpre}enewsgbook where bid='1' and ch……
如题,会员空间反馈信息调用。代码如下:<?
//会员空间反馈 调用
//userid='1' 会员ID
$sql=$empire->query("select ftext,uname,uid from {$dbtbpre}enewsmemberfeedback where userid='1' order by fid desc limit 8")……
帝国CMS高级应用-灵动标签之循环子栏目导航 [e:loop={"select classid,classname,islast from {$dbtbpre}enewsclass where bclassid='0' and showclass=0 order by myorder,classid ASC limit 11",0,24,0}]……
本周热点排行之类的sql标签 [ecmsinfo]"select * from phome_ecms_news where newstime>SUBDATE(NOW(),INTERVAL 7 DAY) order by onclick desc limit 10",10,30,0,24,7,0[/ecmsinfo]
注意:
30 是单位(天,当然你也可以修……
SQL: select a.id,a.classid,a.title,a.titlepic,a.username,a.userid,a.applynum,a.onclick,a.titleurl,b.id,b.classid,count(b.id) fromphome_ecms_news as a left join……
统计记录:select count(*) as total from [!db.pre!]ecms_news where id>(select id from [!db.pre!]ecms_news order by id desc limit 10,1) and checked=1查询记录:select……