[e:loop={"SELECT * , COUNT(bm) AS num FROM cmsmoban_ecms_shop GROUP BY bm ORDER BY num DESC LIMIT 10",10,24,0}]
<li><?=$bqr[num]?> <em><?=$bqr[bm]?></em></li>
[/e:loop]
bm就是我们新建的自定义字段,根据bm字段内容的多少进行排序。
[e:loop={"SELECT * , COUNT(bm) AS num FROM cmsmoban_ecms_shop GROUP BY bm ORDER BY num DESC LIMIT 10",10,24,0}]
<li><?=$bqr[num]?> <em><?=$bqr[bm]?></em></li>
[/e:loop]
bm就是我们新建的自定义字段,根据bm字段内容的多少进行排序。