|
set rs=server.CreateObject("adodb.recordset")
rs.open "select name,dep,mbo,baoyuan from mbo where nian="&nian&" and yue="&yue&" order by id",conn,3,3for i=1 to 10name1=Trim(request("name1"&i)) dep=Trim(request("dep"&i)) mbo=Trim(request("mbo"&i))baoyuan=Trim(request("baoyuan"&i))rs("name")=name1rs("dep")=dep rs("baoyuan")=baoyuanrs("mbo")=mbors.updatenextrs.closeset rs=nothing
<%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
for j= 0 to 1
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
IF RS.EOF=TRUE THEN EXIT for
next
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%>
试试这段。 |
|