帝国cms灵动标签联合查询自定义扩展变量

cms模型

灵动标签联合查询(自定义扩展变量)

[e:loop={"select * from [!db.pre!]enewsclass as a inner join [!db.pre!]ecms_news as b on a.classid=b.classid and a.bclassid=1 order by isgood desc limit 32",0,24,0}] 
<li> 
<section><a href="<?=$bqsr['titleurl']?>" target="_blank"> 
<h2> 
<?=$bqr['gsmc']?> 
</h2> 
</a> 
<p><i>联系人：</i> 
<?=$bqr['lxr']?> 
</p> 
<p><i>联系电话：</i> 
<?=$bqr['lxdh']?> 
</p> 
<p><i>企业地址：</i> 
<?=$bqr['gsdz']?> 
</p> 
<span><i>主营业务：</i> 
<?=$bqr['keyboard']?> 
</span></section> 
</li> 
[/e:loop]