帝国cms灵动标签常用SQL联表查询实例
2016-07-15 23:52:08 稿源: 一商设计
帝国CMS双表联查会员信息调取实例,可根据以下实例对其他表实现双表联查达到最终效果:[e:loop={'SELECT f.*,t.* FROM [!db.pre!]enewsmember f INNER JOIN [!db.pre!]enewsme
帝国CMS双表联查会员信息调取实例,可根据以下实例对其他表实现双表联查达到最终效果:
[e:loop={'SELECT f.*,t.* FROM [!db.pre!]enewsmember f INNER JOIN [!db.pre!]enewsmemberadd t ON f.userid=t.userid WHERE f.groupid=3 ORDER BY f.userid LIMIT 15',0,24,0}]
<li><a href="<?=$bqsr[titleurl]?>" target="_blank" class="blue"><?=$bqr[company]?></a></li>
[/e:loop]