由 dawei
调用会员发布文章数
1
<table>
2
[e:loop={'SELECT userid, username, count(username) as total from [!db.pre!]ecms_news group by username order by total desc',0,24,0}]
3
<tr>
4
<td><?=$bqno?></td>
5
<td><?=$bqr[username]?></td>
6
<td><?=$bqr[total]?></td>
7
</tr>
8
[/e:loop]
9
</table>
2、只调用会员发布文章数，增加（序号、会员id）
01
<table>
02
<tr>
03
<td>排名号</td>
04
<td>会员名</td>
05
<td>文章数</td>
06
<td>会员ID</td>
07
</tr>
08
[e:loop={'select userid, username,count(username) as num from [!db.pre!]ecms_news group by username order by num desc',0,24,0}]
09
<tr>
10
<td><?=$bqno?></td>
11
<td><?=$bqr[username]?></td>
12
<td><?=$bqr[num]?></td>
13
<td><?=$bqr[userid]?></td>
14
</tr>
15
[/e:loop]
16
</table>