Question

asp如何设置商品的横排展示

我的商品表cloth
首页是只显示图片和名称

<%
'以下连接数据库，建立一个Connection对象实例conn
Dim conn,strConn
Set conn=Server.CreateObject("ADODB.Connection")
strConn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("shop.mdb")
conn.Open strConn '利用数据源连接数据库
'以下建立记录集，建立一个Recordset对象实例rs
Dim rs
Set rs=conn.Execute("Select * From cloth") '返回整个数据表
'以下利用表格显示记录集中的记录

%>
<table width="100%" height="296" border="0" cellpadding="0" cellspacing="0">
<tr>
<th height="56" colspan="2" scope="col"><div align="left">潮流服饰</div></th>
</tr>
<%
Do While Not rs.Eof '只要不是结尾就执行循环
%>
<tr>
<td height="192"><a href="clothditail.asp?ID=<%=rs("ID") %>"><img height="242" border="0"width="230" alt="" src='<%=rs("cloth_picture")%>' /></a></td>
<td> </td>
</tr>
<tr>
<td width="20%" height="48"><div align="center"><a href="clothditail.asp?ID=<%=rs("ID") %>"><%=rs("cloth_name")%></a></div></td>
<td width="80%"> </td>
</tr>
<%
rs.MoveNext '将记录指针移动到下一条记录
Loop
%>
</table>
怎么样设置商品的横排展示，我想每排3个或者4个，先谢过了~~~~~~

Answer 1

三拦芦个
<div style="width:800px;">
<%for i=1 to 10%>
<img src="https://gss0.bdstatic.com/70cFsjip0QIZ8tyhnq/hi/img/mfu/my_ico.gif" style="float:left;width:150px;height:150px;margin-left:87px;">
<%next%>
</div>

四个
<div style="width:800px;">
<%for i=1 to 10%>
<简桐带img src="https://gss0.bdstatic.com/70cFsjip0QIZ8tyhnq/hi/img/mfu/my_ico.gif"轮纤 style="float:left;width:150px;height:150px;margin-left:40px;">
<%next%>
</div>

原理是这样

Answer 2

<% rsb.pagesize=16
rsb.AbsolutePage=CutPage
for i=1 to rsb.pagesize
%>
<table width="95%" height="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><型友table width="157" height="101" border="0" align="center" cellpadding="0" cellspacing="0" style="BORDER-RIGHT: #999999 1px solid; BORDER-LEFT:#999999 1px solid ; BORDER-TOP: #999999 1px solid ;BORDER-BOTTOM: #999999 1px solid ">
<tr>
<td><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><img src="<%=rsb("news_link")%>" width="157" height="101" border="0" /></a></td>
</tr>
</table>
<div align="center"><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><%=rsb("news_title")%></a><br />
</div></td>
<%
rsb.movenext
if rsb.eof then exit for
i=i+1
%>
<td><table width="157" height="101" border="0" align="center" cellpadding="0" cellspacing="0" style="BORDER-RIGHT: #999999 1px solid; BORDER-LEFT:#999999 1px solid ; BORDER-TOP: #999999 1px solid ;BORDER-BOTTOM: #999999 1px solid ">
<tr>
<td><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><img src="<%=rsb("news_link"卜冲槐)%>" width="157" height="101" border="0" /></a></td>
</tr>
</table>
<div align="center"><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><%=rsb("news_title")%></a></div></td>
<%
rsb.movenext
if rsb.eof then exit for
i=i+1
%>
<td><table width="157" height="101" border="0" align="center" cellpadding="0" cellspacing="0" style="BORDER-RIGHT: #999999 1px solid; BORDER-LEFT:#999999 1px solid ; BORDER-TOP: #999999 1px solid ;BORDER-BOTTOM: #999999 1px solid ">
<tr>
<td><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><img src="<%=rsb("news_link")%>" width="157" height="101"判御 border="0" /></a></td>
</tr>
</table>
<div align="center"><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><%=rsb("news_title")%></a></div>
</td>
<%
rsb.movenext
if rsb.eof then exit for
i=i+1
%>
<td><table width="157" height="101" border="0" align="center" cellpadding="0" cellspacing="0" style="BORDER-RIGHT: #999999 1px solid; BORDER-LEFT:#999999 1px solid ; BORDER-TOP: #999999 1px solid ;BORDER-BOTTOM: #999999 1px solid ">
<tr>
<td><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><img src="<%=rsb("news_link")%>" width="157" height="101" border="0" /></a></td>
</tr>
</table>
<div align="center"><a href="shownews.asp?lm=<%=id%>&id=<%=rsb("news_id")%>"><%=rsb("news_title")%></a></div></td>
</tr>
</table>
<%
rsb.movenext
if rsb.eof then exit for
next
%>
这是我原来写的 看看是你要的吗