select top 10 id,title,photourl,price from ks_product a inner join ks_product b on a.proinput=b.proinput where b.id={$CurrInfoID} order by id desc

显示特定字段ID....似乎不能运行...我不懂怎么改...

我页面生成HTML,调用这个SQL标签...页面显示"正在读取数据..."等了N个小时也没读取出来..这怎么办啊?

上面的[loop=10],刚才打错了..怎么不能编辑自己的帖子啊...

我在教程区看到自定义SQL函数标签实现连续滚动文章效果,于是想运用到这个SQL标签中

但并没有实现滚动的效果....

SQL语句:select top 10 a.id,a.title,a.photourl,a.price from ks_product a inner join ks_product b on a.proinput=b.proinput where b.id={$CurrInfoID} order by a.id desc

循环体:

<DIV id=demo onmouseover=ii=1 style="OVERFLOW: hidden; HEIGHT: 180px" onmouseout=ii=0>
<DIV id=demo1>
<table width="100%" border="0" cellspacing="0" cellpadding="3">

[loop=20]
<tr>
<td><a href="{$Field(ID,GetInfoUrl,5,1)}"><img src={$Field(photourl,Text,0,...,0,)}</img></a></td>
</tr>
[/loop]

</table>

</DIV>
<DIV id=demo2>
<SCRIPT>
var ii=0;t=demo.scrollTop
demo2.innerHTML=demo1.innerHTML
function qswhMarquee(){
if (ii==1)return
if(demo2.offsetTop-demo.scrollTop<=0)
demo.scrollTop-=demo1.offsetHeight
else
demo.scrollTop++
}
setInterval(qswhMarquee,60)
</SCRIPT></DIV>

忠心感谢版主....

回复的速度一流的快...

select top 10 a.id,a.title,a.photourl,a.price from ks_product a inner join ks_product b on a.proinput=b.proinput where b.id={$CurrInfoID} order by a.id desc

加一个a.吧