Question

Asp关于二级分类的写法??

http://zhidao.baidu.com/question/90004203.html
在网站搜到一段产品目录二级分类写法.但是Crtl+V过去以后发现二级分类是竖首的.可不可以横着写..现在产品的二级分类就是竖着的.我想改成.就像多数网站的产品显示那样.把二级分类横着放.一行三个这样子.源代码如果.谢谢了.解决问题加分

<table width="200" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="200"></td>
</tr>
<tr>
<td valign="top">

<%
Set rsproducts=server.CreateObject ("Adodb.recordset")
sql="select * from products where flang=1 and ID=0"
rsproducts.open sql,conn,1,1
count = 0
do while not rsproducts.eof
productsID =trim(rsproducts("productsID"))
productseID =trim(rsproducts("productseID"))
productsName =trim(rsproducts("productsName"))
productsPic =trim(rsproducts("productsPic"))
%>

<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td width="200" valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td height="30"> <%=productsName%> </td>

</tr>
</tbody>
</table>
<br /></td>
</tr>
<tr>
<td valign="top">
<%
Set rs=server.CreateObject ("Adodb.recordset")
sql="select * from products where productseID="&productsID&""
rs.open sql,conn,1,1
do while not rs.eof
LproductsID =trim(rs("productsID"))
LproductseID =trim(rs("productseID"))
LproductsName =trim(rs("productsName"))
LproductsPic =trim(rs("productsPic"))
%>
<table width="94%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#f5f5f5" class="gray">
<tr valign="top" align="middle">
<td width="10"bgcolor="ffffff"><img src="/images/tou.gif" width="24" height="24" /></td>
<td height="20" valign="top" bgcolor="ffffff"><a href="small.asp?productsID=<%=LproductsID%>&bar=<%=productsID%>"><%=LproductsName%></a></td>
</tr>
</table>
<br />
<%
rs.movenext
loop
rs.close
set rs=nothing
%></td>
</tr>
</table>
<br /></td>
</tr>
</tbody>
</table>
<%
count=count+1
rsproducts.movenext
loop
rsproducts.close
set rsproducts=nothing
conn.close
set conn=nothing
%>
<br /></td>
</tr>
</table>

Answer 1

你这个问题其实不在于分类的说法, 问题本质应该是 "用asp 逐行显示特定数目的记录." 与网站中每行只显示规定数目的图片是同类问题.

给你个这种结构. 你自己套用:

<% for kk=1 to rscl.recordcount %>

<table border="0" cellpadding="0" cellspacing="6" >
<tr>
<!-- XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX -->
<%
ii=1
while(ii<=4 and not rscl.eof) '这是关键.每行显示4个
%>
<!-- ************************************************************ -->
<Td >
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" >
<tr>
<td width="150" height="50" > {$rotate_content$}</td>
</tr>
</table>
</Td>
<!--************************************************************-->
<%
rscl.movenext
ii=ii+1
wend
%>
<!--XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX -->
</tr>
</table>

<% next %>