我站的标签，发给大家参考。

select top 10 b.id,b.title,DiggNum from KS_DiggList a inner join ks_article b on a.infoid=b.id where channelid=1 order by diggnum desc

[loop=10]
  <li style="padding:0 0 0 16px;background: url(/images/g{$AutoID}.gif) transparent no-repeat 0px 4px;"><a target="_blank" href="{$Field(id,GetInfoUrl,1,1)}" title="{$Field(title,Text,0,...,1,)}">{$Field(Title,Text,40,...,1,)}</a>{$Field(DiggNum,Num,0,2)}人推荐</li>
[/loop]

[此贴子已经被作者于2008-2-24 12:00:59编辑过]