可以实现,调用最新300条信息中点中率最高的2条信息,而不是所有信息。[e:loop={'select * from (select a.id,a.title,a.newspath,a.newstime,b.classpath,b.classname,b.filetype,a.onclick,a.smalltext from '.$dbtbpr……
(一)、当前栏目ID或专题ID:$GLOBALS[navclassid]
通过这个变量可以输出这个栏目id的所有数据(如:select * from phome_enewsclass where classid='$GLOBALS[navclassid]')
(二)、使用范例:调用当前栏目下的栏目简介。
用SQ……
帝国CMS 用灵动标签调用最新会员[头像+用户名+链接]:<ul>
[e:loop={'select userid as userid,truename as title,userpic as titlepic from [!db.pre!]enewsmemberadd order by userid desc limit 8',10,24,0}]……
用灵动标签调用调用最新DIGG顶的最多的文章:[e:loop={'select * from [!db.pre!]ecms_news where checked=1 order by diggtop desc,id desc limit 8',10,24,0}]
<li><a href="<?=$bqsr[titleurl]?>"><?=sub($bqr[titl……
用灵动标签调用最新最多评论文章:[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……
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……