在dede:arclist、dede:list等标签中调用附加字段

来源：互联网发布：学做淘宝视频教程全集编辑：程序博客网时间：2024/06/10 03:21

思路：根据主表ID对附加表进行关联查询，即可。

以下实例:

{dede:list perpage='20'}<div class="f-con01"><div class="f-con01-l"><a><img src="/templets/qiba/images/con01-f.jpg"></a></div><div class="f-con01-r"><p class="a6"><a href="[field:arcurl/]" target="_blank">[field:title/]</a></p><p><a>[field:description/]...</a></p><dl><dt>地址：</dt><dd>[field:id runphp="yes"]$dsql = new DedeSql(false);$sql="SELECT qiba.address from `dede_addonqiba` as qiba where qiba.aid=@me";$arcRow = $dsql->GetOne($sql);@me=''.$arcRow['address'].'';[/field:id]</dd><dt>乘车路线：</dt><dd>[field:id runphp="yes"]$dsql = new DedeSql(false);$sql="SELECT qiba.roadline from `dede_addonqiba` as qiba where qiba.aid=@me";$arcRow = $dsql->GetOne($sql);@me=''.$arcRow['roadline'].'';[/field:id]</dd></dl><dl><dt>电话：</dt><dd>[field:id runphp="yes"]$dsql = new DedeSql(false);$sql="SELECT qiba.telephone from `dede_addonqiba` as qiba where qiba.aid=@me";$arcRow = $dsql->GetOne($sql);@me=''.$arcRow['telephone'].'';[/field:id]</dd></dl></div><div class="f-con01-b"><div class="star"><p>评分：</p>        [field:id runphp="yes"]@me=rating_bar(@me,5);[/field:id]</div></div><div class="clear"></div></div>{/dede:list}