如题:

<%
set wasa=server.CreateObject("adodb.recordset")
wasa.Open "select top3 * from vote",conn,1,1
if not wasa.eof then
piao1=trim(wasa("Select3"))
piao1url=trim(wasa("link1"))
piaos1=trim(wasa("tit1"))piao2=trim(wasa("Select4"))
piao2url=trim(wasa("link2"))
piaos2=trim(wasa("tit2"))piao3=trim(wasa("Select5"))
piao3url=trim(wasa("link3"))
piaos3=trim(wasa("tit3"))piao4=trim(wasa("Select6"))
piao4url=trim(wasa("link4"))
piaos4=trim(wasa("tit4"))piao5=trim(wasa("Select7"))
piao5url=trim(wasa("link5"))
piaos5=trim(wasa("tit5"))
else
response.Write("222")
end ifwasa.Close
set wasa=nothing
'piao1="images/1.jpg"
'piao1url=SiteUrl
'piaos1="可立信与马来西亚的关系"
'
'piao2="images/2.jpg"
'piao2url=SiteUrl
'piaos2="可立信与马来西亚的关系"
'
'piao3="images/3.jpg"
'piao3url=SiteUrl
'piaos3="古城红咖啡"
'
'piao4="images/4.jpg"
'piao4url=SiteUrl
'piaos4="古城纤美"
'
'piao5="images/5.jpg"
'piao5url=SiteUrl
'piaos5="神奇的开心果"
 
    pic=piao1&"|"&piao2&"|"&piao3&"|"&piao4&"|"&piao5
        link=piao1url&"|"&piao2url&"|"&piao3url&"|"&piao4url&"|"&piao5url
    texts=piaos1&"|"&piaos2&"|"&piaos3&"|"&piaos4&"|"&piaos5
%><script language="JavaScript">
<!--
function MM_swapImgRestore() { //v3.0
  var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
}function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}function MM_findObj(n, d) { //v4.0
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&blank.frames.length) {
    d=blank.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && document.getElementById) x=document.getElementById(n); return x;
}function MM_swapImage() { //v3.0
  var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
   if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
}
//-->
</script>    
  
  <script language="" type="text/javascript">
<!--

var focus_width=380
var focus_height=275
var text_height=0
var swf_height = focus_height+text_height


var pics='<%=pic%>'
var links='<%=link%>'
var texts='<%=texts%>'
document.write('<object ID="focus_flash" 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="images/pixviewer.swf"><param name="quality" value="high"><param name="bgcolor" value="#F3F3F3">');
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 ID="focus_flash" src="images/pixviewer.swf" wmode="opaque" FlashVars="pics='+pics+'&links='+links+'&texts='+texts+'&borderwidth='+focus_width+'&borderheight='+focus_height+'&textheight='+text_height+'" menu="false" bgcolor="#5A9FB5" 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>
这是我写的,可我不懂变成10张图片?  帮帮忙

解决方案 »

  1.   


    把下面修改一下,改成对应10个的   pic=piao1&"|"&piao2&"|"&piao3&"|"&piao4&"|"&piao5 
          link=piao1url&"|"&piao2url&"|"&piao3url&"|"&piao4url&"|"&piao5url 
      texts=piaos1&"|"&piaos2&"|"&piaos3&"|"&piaos4&"|"&piaos5 
      

  2.   


    不要这么机械嘛.

    piao5=trim(wasa("Select7")) 
    piao5url=trim(wasa("link5")) 
    piaos5=trim(wasa("tit5")) 
    的后面再加上piao6=trim(wasa("Select8")) 
    piao6url=trim(wasa("link6")) 
    piaos6=trim(wasa("tit6")) piao7=trim(wasa("Select9")) 
    piao7url=trim(wasa("link7")) 
    piaos7=trim(wasa("tit7"))..... 
      

  3.   

    那些我 也改了
    可是数据库没有Select7,Select8,Select9,Select10不可以添加字段(前提)