网友您好, 请在下方输入框内输入要搜索的题目:
<div class="top82">
<%set rsp=server.CreateObject("adodb.recordset")
rsp.open "select top 6 * from BigClass Order By BigClassID desc",conn,1,1
if rsp.eof then
response.write "没有类别!"
else
%>
<%while not rsp.eof %>
<div class="class">
<div style=" font-size:14px; font-weight:bold;"><p><%=rsp("BigClassName")%></p></div>
<%set rss=server.CreateObject("adodb.recordset")
rss.open "Select * From Product Where BigClassName='" & rsp("BigClassName") & "'",conn,1,3
if rss.eof then
response.write "没有该类产品!"
else
%> <%while not rss.eof %>
<div class="smallclass"><a href="productshow.asp?ArticleId=<%=rss("ArticleId")%>" target="_blank"><%=rss("Title")%></a></div>
<%rss.movenext
wend %>
<%end if%>
<%rss.close
set rss=nothing%>
</div>
<%rsp.movenext
wend %>
<%end if%>
<%rsp.close
set rsp=nothing%>
</div>
</div>
</div>
参考答案