请版主帮我看看这个SQL终结文章列表是否有问题:
这是从5.52升级6.0的,但是在6.0ps1版本却不能发布栏目,如果去掉这个标签就可以发布了。先将该标签代码列出,请看看是什么问题(我在另外一个帖子里问好长时间了):
select id,title,photourl,keywords,hits,intro,adddate,author,(select count(id) from ks_comment where channelid=1 and infoid=ks_article.id) as commenttotal from KS_Article where tid in({$CurrClassChildID}) and deltf=0 and verific=1 order by id desc
<style>
dt a:link, dt a:visited{font-size:14px;font-weight:bold;color:#003366}
dt a:hover{color:#ff0000;text-decoration:none}
dd {font-size:12px;color:#555;line-height:22px}
.info span{color:#ff6600}
.info a:link,.info a:visited{color:#555;text-decoration:none}
.info a:hover{color:#555}
#main{float:left; width:100%; margin:0; padding:0;}
#left{ float:left; margin:0; padding:0; }
#right{ float:left; margin:4px;padding:6px; }
#clear{clear:both;}
</style>
[loop=10]
<div id= "main ">
{$IF("{$Field(picurl,Text,0,0,0,空)}"<>"空"||<div class="pic" align="left" id="left" style="margin:5px"><a href="{$Field(id,GetInfoUrl,1,1)}"><img src="{$Field(picurl,Text,0,...,0,)}" alt="{$Field(Title,Text,0,...,0,)}" width="80" height="80" /></a></div>||)}
<div id="right">
<dl>
<dt>
<img src="../../Images/index_03.gif" width="5" height="9" align="absmiddle"/> <a href='{$Field(id,GetInfoUrl,1,1)}'>{$Field(Title,Text,80,...,0,)} </a></dt>
<dd >{$Field(intro,Text,185,...,0,)}</dd>
<dd class="info"><span>更新时间:</span> {$Field(Adddate,Date,YYYY-MM-DD)} <span> 作者:</span> {$Field(author,Text,0,...,0,)} <span> 评论总数:</span> {$Field(commenttotal,Num,0,2)}<span> 点击次数:</span> <font color=red>{$Field(hits,Num,0,2)}</font></dd>
</dl>
</div><div id="clear"></div>
<div style="border-bottom:#ccc 1px dashed"></div>
[/loop]