帝国cms统计使用自定义字段的数量并按照统计的多少进行排序
[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就是我们新建的自定义字段,根……
[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字段内容的多少进行排序。