刚商业区看有用户需要,特分享一下:

sql语句:

select top 10 username,score from ks_USER order by score desc,id

循环体:

<table>
<tr>
 <td>用户</td>
 <td>积分</td>
</tr>
[loop=10]

<tr>
 <td><a href="/space/?{$Field(username,Text,0,...,0,)}" target="_blank">{$Field(username,Text,0,...,0,)}</a></td>

 <td>{$Field(score,Num,0,2)}分</td>
</tr>

[/loop]
</table>