[ÇóÖú]ÔõôʵÏÖË«ÅÅÏÔʾ

DJ°®ÓжàÍ´DJ

ÏÔʾ˫ÅÅÓ¦¸ÃÔõô¸Ä£¬¸÷λÐǪ̈°ïÎÒ¿´¿´¡£Ô­ÂëÈçÏ£º
<%set rs = conn.execute("select top 5 id,mc,rq from vod where lbid="&lb("lbid")&" order by id desc")
do while not rs.eof
Response.Write("<tr><td height=22>&nbsp;<img src=image/dot.gif align=absmiddle>&nbsp;<a href=xiangxi.asp?id="&rs("id")&">"&rs("mc")&"</a>&nbsp;&nbsp;[<font color=#ff6600>"&rs("rq")&"</font>]</td></tr>")
rs.movenext
loop
rs.close
set rs=nothing%></table></td>
</tr></table>
</td>
<%if i mod 2 = 0 then%>
</tr>
<%end if
lb.movenext
i=i+1
loop
lb.close
set lb=nothing%>
¸½¼þ: Ö»Óб¾Õ¾»áÔ±²ÅÄÜÏÂÔØ»ò²é¿´¸½¼þ£¬ÇëÄú µÇ¼ »ò ×¢²á

·çÖÒÈË

set rs=server.CreateObject("adodb.recordset")
rs.open "select name,dep,mbo,baoyuan from mbo where nian="&amp;nian&amp;" and yue="&amp;yue&amp;" order by id",conn,3,3for   i=1   to  10name1=Trim(request("name1"&amp;i)) dep=Trim(request("dep"&amp;i)) mbo=Trim(request("mbo"&amp;i))baoyuan=Trim(request("baoyuan"&amp;i))rs("name")=name1rs("dep")=dep rs("baoyuan")=baoyuanrs("mbo")=mbors.updatenextrs.closeset rs=nothing





&lt;%set rs = conn.execute("select top 5 id,mc,rq from vod where lbid="&amp;lb("lbid")&amp;" order by id desc")
do while not rs.eof
for j= 0 to 1
Response.Write("&lt;tr&gt;&lt;td height=22&gt;&amp;nbsp;&lt;img src=image/dot.gif align=absmiddle&gt;&amp;nbsp;&lt;a href=xiangxi.asp?id="&amp;rs("id")&amp;"&gt;"&amp;rs("mc")&amp;"&lt;/a&gt;&amp;nbsp;&amp;nbsp;[&lt;font color=#ff6600&gt;"&amp;rs("rq")&amp;"&lt;/font&gt;]&lt;/td&gt;&lt;/tr&gt;")
                 &lt;%
      Rs.movenext
      IF RS.EOF=TRUE THEN EXIT for
    next
   
rs.close
set rs=nothing%&gt;&lt;/table&gt;&lt;/td&gt;
              &lt;/tr&gt;&lt;/table&gt;
          &lt;/td&gt;
          &lt;%if i mod 2 = 0 then%&gt;
        &lt;/tr&gt;
&lt;%end if
lb.movenext
i=i+1
loop
lb.close
set lb=nothing%&gt;
ÊÔÊÔÕâ¶Î¡£