Question

这样的asp代码怎么改成横向的？现在是竖着放的,我想改成2列4行显示

<%dim recommend
recommend=request("recommend")
sql="select top 4 * from product where recommend=1 order by dateandtime desc"
set rs=conn.execute(sql)%> <%
while not rs.eof
%> <table width="100%" border="0" cellspacing="2" cellpadding="1">
<tr>
<td> <div align="center">
<p>
<% if rs("images")="" then %>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="images/nopic.gif" border="0"></a>
<%else%>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="<%=rs("images")%>" border="0" width="95" height="95"></a>
<%end if%>
</p>
<p><font style=line-height:150%>名称：<a href="productview.asp?id=<%=rs("productid")%>" title=<%=left(rs("Nkey"),20)%>><%=left(rs("title"),13)%>...</a><br>
价格：
<%if not isnull(rs("price")) then%>
<%=rs("price")%>
<%else%>
不详
<%end if%>
</font></p>
</div></td>
</tr>
<tr>
<td height="5" background="images/bg.gif"></td>
</tr>
</table>
<%rs.movenext
wend
rs.close
'set rs=nothing
'conn.close
'set conn=nothing %>

Answer 1

<!--///////////////设置一个计数器就可以了////////////-->
<%dim recommend
recommend=request("recommend")
sql="select top 8 * from product where recommend=1 order by dateandtime desc"
set rs=conn.execute(sql)
i=0
%>
<table width="100%" border="0" cellspacing="2" cellpadding="1">
<tr>
<%while not rs.eof
i=i+1%>
<td><div align="center">
<p>
<% if rs("images")="" then %>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="images/nopic.gif" border="0"></a>
<%else%>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="<%=rs("images")%>" border="0" width="95" height="95"></a>
<%end if%>
</p>
<p><font style=line-height:150%>名称：<a href="productview.asp?id=<%=rs("productid")%>" title=<%=left(rs("Nkey"),20)%>><%=left(rs("title"),13)%>...</a><br>
价格：
<%if not isnull(rs("price")) then%>
<%=rs("price")%>
<%else%>
不详
<%end if%>
</font></p>
</div></td>
<%
if i mod 2=0 then Response.Write("</tr><tr>")
rs.movenext
wend %>
</tr>
</table>
<%
rs.close
'set rs=nothing
'conn.close
'set conn=nothing %>

Answer 2

<%dim recommend
recommend=request("recommend")
sql="select top 4 * from product where recommend=1 order by dateandtime desc"
set rs=conn.execute(sql)%>
<table width="100%" border="0" cellspacing="2" cellpadding="1">
<%
while not rs.eof
%>
<tr>
<td> <div align="center">
<p>
<% if rs("images")="" then %>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="images/nopic.gif" border="0"></a>
<%else%>
<a href="productview.asp?id=<%=rs("productid")%>"><img src="<%=rs("images")%>" border="0" width="95" height="95"></a>
<%end if%>
</p>
<p><font style=line-height:150%>名称：<a href="productview.asp?id=<%=rs("productid")%>" title=<%=left(rs("Nkey"),20)%>><%=left(rs("title"),13)%>...</a><br>
价格：
<%if not isnull(rs("price")) then%>
<%=rs("price")%>
<%else%>
不详
<%end if%>
</font></p>
</div>
</td>
</tr>
<tr>
<td height="5" background="images/bg.gif"></td>
</tr>
<%rs.movenext
wend
%>
</table>
<%
rs.close
'set rs=nothing
'conn.close
'set conn=nothing %>