灵动标签统计某表数据:
[e:loop={"select count(*) as title from [!db.pre!]ecms_info where ismember=1 and checked=1",1,24,0}]
总数:<font color="red"><?=$bqr[title]?></font>[/e:loop]条
某表某栏目统计:
[e:loop={"select count(*) as title from [!db.pre!]ecms_info where ismember=1 and checked=1 and classid=20",1,24,0}]
总数:<font color="red"><?=$bqr[title]?></font>[/e:loop]条
调用会员总数:
[e:loop={"select count(*) as title from [!db.pre!]enewsmember where checked=1",1,24,0}]
总数:<font color="red"><?=$bqr[title]?></font>[/e:loop]个
......
自己站里用到的 友情连接调用
[e:loop={'select * from [!db.pre!]enewslink where checked=1 order by lid desc limit 7',20,24,0}]
<TD><a href="<?=$bqr[lurl]?>"><?=$bqr[lname]?></a></TD>
[/e:loop]