就把我的帖上来吧,根据自己需要修改下。
评论select top 12 ID,ChannelID,InfoID,Content,AddDate from KS_Comment where verific=1 order by adddate desc
[loop=12]
<img src="/UpFiles/blue.gif" border="0"><a target="_blank" title="{$Field(Content,Text,0,...,2,)}" href="/plus/Comment.asp?ChannelID={$Field(channelid,Num,0,2)}&ClassID={$Field(classid,Num,0,2)}&InfoID={$Field(infoid,Num,0,2)}">{$Field(content,Text,46,...,2,)}</a> ({$Field(AddDate,Date,MM-DD)})<br />
[/loop]
留言select top 10 id,AddTime,Memo,Name from KS_GuestBook order by id desc
[loop=7]
<img border="0" src="/images/editfile.gif">[{$Field(Name,Text,10,...,2,)}]-{$Field(Memo,Text,36,...,2,)} ({$Field(AddTime,Date,MM-DD)})
<br />
[/loop]