帝国cms模板里调用前台会员名及投稿数量排名的代码

以下是调用代码：会员投稿新闻数据表的排行榜
<table>  
[e:loop={'SELECT userid, username, COUNT( userid ) AS total FROM phome_ecms_news GROUP BY userid',10,24,0,'','total DESC'}]  
<tr>  
<td><?=$bqno?></td>  
<td><?=$bqr[username]?></td>  
<td><?=$bqr[total]?></td>  
</tr>  
[/e:loop]  
</table>
全选代码复制