首页 > 产品展示
<%
set rs=server.createobject("adodb.recordset")
sql="select* from nbigarea where 1=1"
rs.open sql,conn,1,1
if rs.recordcount mod 2=0 then
max=rs.recordcount/2
else
max=rs.recordcount/2+1
end if
%>
<%
if not rs.eof then
for i=1 to max
%>
<%
for j=1 to 2
if rs.eof then exit for
%>
<%=rs("nbigarea")%>
<%
set rss=server.createobject("adodb.recordset")
sql="select top 1 * from pud where nbigarea="&rs("id")&" order by id desc"
rss.open sql,conn,1,1
if not rss.eof then
%>
<%
else
response.write("暂时没有图片")
end if
rss.close
set rss=nothing
%>
<%
set rs1=server.createobject("adodb.recordset")
sql="select * from pud where nbigarea="&trim(rs("id"))&" order by id desc"
rs1.open sql,conn,1,1
%>
|
<%
rs.movenext
next
%>
<%
next
else
response.write("dsfds")
end if
%>