sql如何调用下载栏目的图片及标题,因为用自带的标签排版效果不太好,我用sql调用,结果cpu占用率总是100%
select top 1 ID,Title,PhotoUrl from KS_DownLoad where Verific=1 and DelTF=0 and Recommend=1 and Tid in (select KS_Class.ID from KS_Class where KS_Class.TS like '%20060574998296%') order by Adddate desc
[loop=1]
<div>
<span><a href="{$Field(id,GetInfoUrl,3,1)}"><img src="{$Field(PhotoUrl,Text,0,...,0,)}" border="0" height=120 width=70 ></a></span>
<h1><a href="{$Field(id,GetInfoUrl,3,1)}">{$Field(title,Text,60,,0,)}</a></H1></DIV>
不知道是什么原因,请帮我看看问题出在哪里