以下是SQL代码：
select top 9 ArticleID,ChannelID,Title,DefaultPicUrl from PE_Article where ChannelID ={input(0)} and Status =3 and Deleted=False and DefaultPicUrl like '%.%'order by ArticleID desc

以下是标签代码：
<script type="text/javascript">
<!--{Loop}
{Infobegin}
imgUrl{$AutoID}="{$InstallDir}{$Field(1,GetChannel,1)}/{$Field(1,GetChannel,3)}/{$Field(3,Text,0,0,0)}"
imgLink{$AutoID}="{$InstallDir}{$Field(0,GetUrl,Article,1)}"
imgtext{$AutoID}="{$Field(2,Text,26,1,0)}"{Infoend}
{Infobegin}
{/Loop}
var interval_time={input(1)} //图片停顿时间，单位为秒，为0则停止自动切换
var focus_width={input(2)} //宽度
var focus_height={input(3)} //高度
var text_height={input(4)} //标题高度
var text_align= 'center'
var swf_height = focus_height+text_height //相加之和最好是偶数,否则数字会出现模糊失真的问题
var pics=imgUrl1+"|"+imgUrl2+"|"+imgUrl3+"|"+imgUrl4+"|"+imgUrl5+"|"+imgUrl6+"|"+imgUrl7+"|"+imgUrl8+"|"+imgUrl9
var links=imgLink1+"|"+imgLink2+"|"+imgLink3+"|"+imgLink4+"|"+imgLink5+"|"+imgLink6+"|"+imgLink7+"|"+imgLink8+"|"+imgLink9
var texts=imgtext1+"|"+imgtext2+"|"+imgtext3+"|"+imgtext4+"|"+imgtext5+"|"+imgtext6+"|"+imgtext7+"|"+imgtext8+"|"+imgtext9
document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=8,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
document.write('<param name="movie" value="{$InstallDir}Skin/xinxiu2008/xman.swf"><param name="quality" value="high"><param name="bgcolor" value="#cccccc">');
document.write('<param name="menu" value="false"><param name=wmode value="opaque">');
document.write('<param name="FlashVars" value="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'&text_align='+text_align+'&interval_time='+interval_time+'">');
document.write('<embed src="{$InstallDir}Skin/xinxiu2008/xman.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'&text_align='+text_align+'&interval_time='+interval_time+'" menu="false" bgcolor="#ffffff" quality="high" width="'+ focus_width +'" height="'+ swf_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />');
document.write('</object>');
//-->
</script>