1、调用会员发布文章数table[e:loop={SELECT userid, username, count(username) as total from [!db.pre!]ecms_news group by username order by total desc,0,24,0}]trtd=$bqno/tdtd=$bqr[username]
[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字段内容的多