V9.5用SQL调用用户真实姓名发表文章排行

查询词句

select top 10 a.userid,a.realname,totalNum from ks_user a,(select inputer,count(*) as totalnum from ks_iteminfo where verific=1 group by inputer)b where

a.username=b.inputer order by b.totalnum desc
循环体

<table>
<tr><td>用户名</td><td>稿件数</td></tr>
[loop=10]
<tr><td>{$Field(username,Text,0,...,0,)}</td><td>{$Field(totalnum,Num,0,2)}</td></tr>
[/loop]
</table>

抱歉！循环体是：

<table>

<tr><td>用户名</td><td>稿件数</td></tr>

[loop=10]

<tr><td>{$Field(realname,Text,0,...,0,)}</td><td>{$Field(totalnum,Num,0,2)}</td></tr>

[/loop]

</table>