<%
set rs=server.CreateObject("adodb.recordset")
sql="select top 1 * from book where lei=0 order by cptj desc, id desc"
rs.open sql,conn,1,1
if not rs.eof then
%>
<%
sql1="select top 9 * from zz_type order by id asc"
set rs1=server.CreateObject("ADODB.recordset")
rs1.Open sql1,dbconn,3,3
if not(rs1.eof and rs1.BOF) then
while not rs1.eof
%>
<%
sql="select * from link where type1='首页中部广告(510*130)'"
set rs=server.CreateObject("ADODB.recordset")
rs.Open sql,dbconn,3,3
if not rs.eof then
if lcase(right(rs("gg_file"),3))="swf" then
response.write("")
else
response.write("")
end if
end if
rs.close
set rs=nothing
%>
<%'
set rs=server.CreateObject("adodb.recordset")
sql="select * from news where type1='重点新闻' order by id desc"
rs.open sql,conn,1,1
if not rs.eof then
%>
<%'
set rs=server.CreateObject("adodb.recordset")
sql="select top 4 * from news where type1='反馈新闻' order by id desc"
rs.open sql,conn,1,1
if not rs.eof then
i=1
do while not rs.eof
%>
<% i=i+1
rs.movenext
loop
rs.close
set rs=nothing
end if
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from news where type1='观点新闻' and tj=1 order by id desc"
rs.open sql,conn,1,1
if not rs.eof then
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select top 6 * from news where type1='观点新闻' and tj=0 order by id desc"
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
%>
<% i=i+1
rs.movenext
loop
rs.close
set rs=nothing
end if
%>
<%
sql="select * from link where type1='首页右侧上广告(215*112)'"
set rs=server.CreateObject("ADODB.recordset")
rs.Open sql,dbconn,3,3
if not rs.eof then
if lcase(right(rs("gg_file"),3))="swf" then
response.write("")
else
response.write("")
end if
end if
rs.close
set rs=nothing
%>
<%
sql="select * from link where type1='首页右侧下广告(215*112)'"
set rs=server.CreateObject("ADODB.recordset")
rs.Open sql,dbconn,3,3
if not rs.eof then
if lcase(right(rs("gg_file"),3))="swf" then
response.write("")
else
response.write("")
end if
end if
rs.close
set rs=nothing
%>
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from book where lei=1 "
rs.open sql,conn,1,1
if not rs.eof then
%>
友情链接:
<%
sql1="select * from other_link where type1='友情链接'"
set rs1=server.CreateObject("ADODB.recordset")
rs1.Open sql1,dbconn,3,3
if not rs1.eof then
do while not rs1.eof%>
" target="_blank">" border="0" />
<%rs1.movenext
loop
end if
rs1.close
set rs1=nothing
%>