<% Set rs=server.createobject("adodb.recordset") i=1 rs.open "select * from channel1 where idtop=1 order by torder asc",conn,1,1 do while not rs.eof if i=1 then %>
  • <%=rs("channel")%>
  • <% else %>
  • <%=rs("channel")%>
  • <% end if i=i+1 rs.movenext loop rs.close set rs=nothing %>
更多>>
<% Set rs=server.createobject("adodb.recordset") j=1 rs.open "select * from channel1 where idtop=1 order by torder asc",conn,1,1 do while not rs.eof if j=1 then %>
    <% Set rsn=server.createobject("adodb.recordset") n=1 sqln="select top 6 * from articles1 where style='"&rs("id")&"' and tj=1 order by tj desc,updatetime desc" rsn.open sqln,conn,1,1 if not rsn.eof then do while not rsn.eof l=n mod 2 if l=1 then %>
  • <%=year(rsn("updatetime"))%>-<%=month(rsn("updatetime"))%>-<%=day(rsn("updatetime"))%>"> <% = left(rsn("title"),20) %>
  • <% else %>
  • <%=year(rsn("updatetime"))%>-<%=month(rsn("updatetime"))%>-<%=day(rsn("updatetime"))%>"> <% = left(rsn("title"),20) %>
  • <% end if rsn.movenext n=n+1 loop end if rsn.close set rsn=nothing%>
<% else %> <% end if j=j+1 rs.movenext loop rs.close set rs=nothing %>
终端展示 联系电话:13802541849
产品展示
<% set rs=server.createobject("adodb.recordset") sql="select top 10 * from articles where tj=1 order by hits,updatetime desc" rs.open sql,conn,1,1 if rs.eof then %>
暂时没有数据!
<%else do while not rs.eof %> <% rs.movenext loop end if rs.close set rs=nothing%>