图片轮流更换代码 带数据库动态更新
<%
sql = "select top 5 * from website order by id Desc"
rs.open sql,conn,1,1
dim pic(5),url(5),text(5)
for i =0 to 4
pic(i)=rs("pic")
url(i)=Rs("url")
text(i)=rs("name")
rs.movenext
if rs.eof then exit for
next
rs.close
%><a target=_self href="javascript:goUrl()"> <span class="f14b">
<script type="text/javascript">
imgUrl1="<%=pic(0)%>";
imgtext1="<%=text(0)%>";
imgLink1=escape("<%=url(0)%>");
imgUrl2="<%=pic(1)%>";
imgtext2="<%=text(1)%>";
imgLink2=escape("<%=url(1)%>");
imgUrl3="<%=pic(2)%>";
imgtext3="<%=text(2)%>";
imgLink3=escape("<%=url(2)%>");
imgUrl4="<%=pic(3)%>";
imgtext4="<%=text(3)%>";
imgLink4=escape("<%=url(3)%>");
imgUrl5="<%=pic(4)%>";
imgtext5="<%=text(4)%>";
imgLink5=escape("<%=url(4)%>");
var focus_width=302
var focus_height=230
var text_height=18
var swf_height = focus_height+text_height
var pics=imgUrl1+"|"+imgUrl2+"|"+imgUrl3+"|"+imgUrl4+"|"+imgUrl5
var links=imgLink1+"|"+imgLink2+"|"+imgLink3+"|"+imgLink4+"|"+imgLink5
var texts=imgtext1+"|"+imgtext2+"|"+imgtext3+"|"+imgtext4+"|"+imgtext5
document.write('<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0" width="'+ focus_width +'" height="'+ swf_height +'">');
document.write('<param name="allowScriptAccess" value="sameDomain"><param name="movie" value="focus.swf"><param name="quality" value="high"><param name="bgcolor" value="#F0F0F0">');
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+'">');
document.write('<embed src="pixviewer.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#F0F0F0" quality="high" width="'+ focus_width +'" height="'+ focus_height +'" allowScriptAccess="sameDomain" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />'); document.write('</object>');
</script>
</span></a><span id=focustext class=f14b> </span>