-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 12 * from shuaiweb_products order by id desc"
rs.open sql,dbok,1,1
do while not rs.eof and not rs.bof
%>
- ">" width="120" height="160" />
<%=rs("shuaiweb_productsname")%>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 8 * from shuaiweb_products where shuaiweb_productsclass2=4"
rs.open sql,dbok,1,1
do while not rs.eof and not rs.bof
%>
- ">" width="120" height="160" />
<%=rs("shuaiweb_productsname")%>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
公司新闻
-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from shuaiweb_news where shuaiweb_newssort=2 order by id desc"
rs.open sql,dbok,1,1
i=1
do while not rs.eof and not rs.bof
if i=10 then
%>
- "><%=rs("shuaiweb_newstitle")%> <%else %>
- "><%=rs("shuaiweb_newstitle")%> <%end if rs.movenext i=i+1 loop rs.close set rs=nothing %>
-
<%
set rs=server.createobject("adodb.recordset")
sql="select * from shuaiweb_products where shuaiweb_productsclass2=2"
rs.open sql,dbok,1,1
do while not rs.eof and not rs.bof
%>
- ">" width="120" height="160" />
<%=rs("shuaiweb_productsname")%>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
行业动态
-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from shuaiweb_news where shuaiweb_newssort=2 order by id desc"
rs.open sql,dbok,1,1
i=1
do while not rs.eof and not rs.bof
if i=10 then
%>
- "><%=rs("shuaiweb_newstitle")%> <%else %>
- "><%=rs("shuaiweb_newstitle")%> <%end if rs.movenext i=i+1 loop rs.close set rs=nothing %>
天锦车主
更多>>-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from shuaiweb_news where shuaiweb_newssort=4 order by id desc"
rs.open sql,dbok,1,1
i=1
do while not rs.eof and not rs.bof
%>
"><%=rs("shuaiweb_newstitle")%>
[<%=month(rs("time"))%>-<%=day(rs("time"))%>]
<%
rs.movenext
i=i+1
loop
rs.close
set rs=nothing
%>
新闻中心
更多>>-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from shuaiweb_news order by id desc"
rs.open sql,dbok,1,1
i=1
do while not rs.eof and not rs.bof
%>
<%set rs1=server.createobject("adodb.recordset")
sql1="select * from shuaiweb_newsclass where id="&rs("shuaiweb_newssort")
rs1.open sql1,dbok,1,1
newclass=rs1("shuaiweb_classname")
%>
">【<%=newclass%>】<%=rs("shuaiweb_newstitle")%>
[<%=month(rs("time"))%>-<%=day(rs("time"))%>]
<%
rs1.close
set rs1=nothing
rs.movenext
i=i+1
loop
rs.close
set rs=nothing
%>
汽车保养
-
<%
set rs=server.createobject("adodb.recordset")
sql="select top 10 * from shuaiweb_news where shuaiweb_newssort=5 order by id desc"
rs.open sql,dbok,1,1
i=1
do while not rs.eof and not rs.bof
%>
- "><%=rs("shuaiweb_newstitle")%> <% rs.movenext i=i+1 loop rs.close set rs=nothing %>
友情链接