11.1 应用举例 联合查询

[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]