cpzs.asp

北京商务网

<%@ codepage ="936" %>
<!--#include file="../conn/dbconn1.asp"-->
<!--#include file="config.asp"-->
<%
const TbMax=1
tbsql="select * from banner where bz=2 order by LinkID"
Set tbrs= Server.CreateObject("ADODB.Recordset") 
tbrs.open tbsql,conn,1,1 
%>
<%do while not tbrs.eof%> 
document.write('<a href="<%=tbrs("web")%>"><img border=0 src="<%=PicUrl+tbrs("picurl")%>" alt="<%=tbrs("deseriptor")%>" width="180" height="65"></a> &nbsp;&nbsp;')
<% b=b+1 
if b>=TbMax then exit do 
tbrs.movenext 
loop 
tbrs.close 
set tbrs=nothing
conn.close
set conn=nothing 
%>