帝国CMS7.5模板友情链接SQL调用代码标签

1. 调用文字链接

    

    

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

2. 调用带图片的链接

    

    

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

3. 调用指定分类的链接

    

    

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