有人发过 在发一下

select top 10 a.UserName,AddTime,Subject,Memo,content from KS_GuestBook a,KS_GuestReply b where a.id=b.topicid order by a.id desc

<a href="post.asp{$PostBoardID}"><img src="/images/writebook.gif"></a><br><br>
[loop=10]
<table width="99%" border="0" cellspacing="0" cellpadding="5" style="border:1px solid #999999">
  <tr>
    <td height="20" bgcolor="#CCCCCC" style="padding:3px;COLOR:#000000"><b>问:</b>{$Field(Subject,Text,0,...,0,)}&nbsp;&nbsp;&nbsp;[{$Field(UserName,Text,0,...,0,)}]{$Field(AddTime,Text,0,...,0,)}</td>
  </tr>
  <tr>
    <td style="padding:3px;">{$Field(Memo,Text,0,...,0,)}</td>
  </tr>
  <tr>
    <td height="20" style="color:#3399FF;padding:3px;"><b>答:</b>{$Field(content,Num,0,2)}</td>
  </tr>
</table><br>
[/loop]

演示地址：http://www.zhizhi.cc/club/guestbook.asp