以下是调用代码:会员投稿新闻数据表的排行榜
<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>