11.7 应用举例 友情链接

[e:loop={'select * from [!db.pre!]enewslink where checked=1 and classid=1 order by myorder',20,24,0}]
<li><a href="<?=$bqr[lurl]?>" target="_blank"><?=$bqr[lname]?></a></li>
[/e:loop]

图片友情链接

[e:loop={'select lname,lurl,lpic from [!db.pre!]enewslink where checked=1 and classid=5 order by myorder,lid',3,24,0}]
<li><a href="<?=$bqr[lurl]?>" target="_blank" ><img src="<?=$bqr[lpic]?>"></a></li>
[/e:loop]

联合查询

[e:loop={'select b.*,a.* from [!db.pre!]enewslinkclass as a,[!db.pre!]enewslink as b where a.classid=b.classid order by myorder',20,24,0}]
<div class="whitebg">
    <h2 class="htitle"><?=$bqr[classname]?></h2>
    <ul class="site_tj site_yx">
   <li><a href="<?=$bqr[lurl]?>" target="_blank"><?=$bqr[lname]?></a></li>
 </ul>
</div>
[/e:loop]