链接到文章的SQL评论调用标签 由zhenfengdz版主提供

select top 100 C.ChannelID,C.InfoID,C.AnounName,C.Content,C.AddDate,A.ID,A.Tid,A.Title,A.Fname,L.ID,L.Folder from (KS_Article A inner join KS_Comment C on A.ID=C.InfoID)inner join KS_Class L on A.Tid=L.ID where C.verific=1 and C.ChannelID=1 order by C.adddate desc

<table cellpadding="0" border="0" cellspacing="0" width="100%">[loop=100]
<tr height="21">
<td style="border-bottom-width: 1px;border-bottom-style: dashed;border-bottom-color: #E8E8E8">{$AutoID} <a target="_blank" href="/Article/{$Field(Folder,Text,0,...,0,)}{$Field(Fname,Text,0,...,0,)}">{$Field(Title,Text,30,...,1,)}</a>
<font color="#FF0000">评论内容：</font>{$Field(Content,Text,56,...,2,)} -
<font color="#0000FF">评论者：</font>{$Field(AnounName,Text,0,...,2,)} -
<font color="#008000">评论日期：</font>{$Field(AddDate,Date,YYYY-MM-DD)}</td>
</tr>[/loop]
</table>