 产品销售 |
 |
<%
sql="select CategoryID,CategoryName from Category order by ShowOrder asc,CategoryID asc"
frs.open sql,conn,3,1
do while not frs.eof
%>
| |
<%=frs("CategoryName")%> |
">更多.. |
|
<%sql="select top 4 ProductID,ProductName,SmallPic from Product where CategoryID="&frs("CategoryID")&" order by ProductID Desc"
rs.open sql,conn,3,1
for i=1 to rs.recordcount%>
|
|
<%rs.movenext
next
rs.close
%>
|
<%
frs.movenext
loop
frs.close
%>
|
|
|
首页
信息反馈