新闻中心
 
<% set rs1=Server.CreateObject("Adodb.RecordSet") Sql1="select top 7 * from news order by duoxuan3 desc, px asc,id desc" rs1.Open Sql1,Conn,1,1 if not(rs1.eof or rs1.bof) then do while rs1.eof<>true set rsc=server.createobject("adodb.recordset") sqlc="select * from newscata where id="&rs1("cataid")&" order by id desc" rsc.open sqlc,conn,1,1 if not(rsc.bof or rsc.eof) then lname=rsc("cname") else lname="。。。。" end if rsc.close set rsc=nothing %>
" target="_self"> [<%=left(lname,4)%>]<%=strleft(rs1("title"),19)%>
<% rs1.movenext loop end if rs1.close set rs1=nothing %>
 产品展示
 
<% glid=request.QueryString("id") set rs1=Server.CreateObject("Adodb.RecordSet") Sql1="select top 8 * from p order by duoxuan3 desc, px asc, id desc" rs1.Open Sql1,Conn,1,1 if not(rs1.eof or rs1.bof) then do while rs1.eof<>true %> <% rs1.movenext loop end if rs1.close set rs1=nothing %>