注册 登录
编程论坛 ASP技术论坛

ASP表格循环代码

jingfang_434 发布于 2015-01-05 15:43, 2260 次点击
我这个代码想让商品列表变成2列的,怎么修改呢?请高手帮助
<%
set rs=server.createobject("adodb.recordset")
if bid="" then
sql="select * from pic order by id desc"
end if
if bid<>"" and sid="" then
sql="select * from pic where bigclassname='"&rsb("bigclassname")&"' order by id desc"
end if
if bid<>"" and sid<>"" then
sql="select * from pic where bigclassname='"&rsb("bigclassname")&"' and smallclassname='"&rss("smallclassname")&"' order by id desc"
end if
rs.open sql,conn,1,1
if rs.eof then
  Response.Write "<br><center>没有产品信息</center>"
  else
  counts=10
  rs.pagesize=counts
  allpages=rs.pagecount
  page=request("page")
  if not isnumeric(page) then page=1
  if isempty(page) or cint(page)<1 then
  page=1
  elseif cint(page)>=allpages then
  page=allpages
  end if
  rs.absolutepage=page
  end if
  do while (not rs.eof) and counts>0
%>        
         
         
          <TABLE
            style="BORDER-RIGHT: #cccccc 1px solid; BORDER-TOP: #cccccc 1px solid; FLOAT: left; MARGIN: 5px 12px; BORDER-LEFT: #cccccc 1px solid; BORDER-BOTTOM: #cccccc 1px solid"
            height=150 cellSpacing=0 cellPadding=0 width="100%" border=0>
              <TBODY>
                <TR>
                  <TD class=pl23 align=middle width=160 rowSpan=2><A
                  href="showproduct.asp?id=<%=rs("id")%>"><IMG
                  height=120 src="<%=rs("photo")%>"
                  width=150 border=0></A></TD>
                  <TD class=pla2
                style="PADDING-LEFT: 10px; FONT-SIZE: 12px; TEXT-ALIGN: left"
                height=40><A
                  style="FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #333333"
                  href="showproduct.asp?id=<%=rs("id")%>"><%=rs("title")%></A></TD>
                </TR>
                <TR>
                  <TD class=pl1a
                style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12px; PADDING-BOTTOM: 10px; LINE-HEIGHT: 22px; PADDING-TOP: 10px"
                vAlign=top align=left><%=CutStrX(rs("content"),220)%></TD>
                </TR>
              </TBODY>
            </TABLE>
            
<%
    counts=counts-1
    rs.movenext
    if rs.eof then exit do
    loop
%>
4 回复
#2
hu9jj2015-01-05 19:46
试试:
                <TR>
                  <TD class=pl23 align=middle width=160 rowSpan=2><A
                  href="showproduct.asp?id=<%=rs("id")%>"><IMG
                  height=120 src="<%=rs("photo")%>"
                  width=150 border=0></A></TD>
                  <TD class=pla2
                style="PADDING-LEFT: 10px; FONT-SIZE: 12px; TEXT-ALIGN: left"
                height=40><A
                  style="FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #333333"
                  href="showproduct.asp?id=<%=rs("id")%>"><%=rs("title")%></A></TD>
                  <TD class=pl1a
                style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12px; PADDING-BOTTOM: 10px; LINE-HEIGHT: 22px; PADDING-TOP: 10px"
                vAlign=top align=left><%=CutStrX(rs("content"),220)%></TD>
                   <TD class=pl23 align=middle width=160 rowSpan=2><A
                  href="showproduct.asp?id=<%=rs("id")%>"><IMG
                  height=120 src="<%=rs("photo")%>"
                  width=150 border=0></A></TD>
                 counts=counts-1
                 rs.movenext
                  <TD class=pla2
                style="PADDING-LEFT: 10px; FONT-SIZE: 12px; TEXT-ALIGN: left"
                height=40><A
                  style="FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #333333"
                  href="showproduct.asp?id=<%=rs("id")%>"><%=rs("title")%></A></TD>
                  <TD class=pl1a
                style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12px; PADDING-BOTTOM: 10px; LINE-HEIGHT: 22px; PADDING-TOP: 10px"
                vAlign=top align=left><%=CutStrX(rs("content"),220)%></TD>
                <TD class=pl23 align=middle width=160 rowSpan=2><A
                  href="showproduct.asp?id=<%=rs("id")%>"><IMG
                  height=120 src="<%=rs("photo")%>"
                  width=150 border=0></A></TD>
               </TR>

[ 本帖最后由 hu9jj 于 2015-1-5 19:48 编辑 ]
#3
jingfang_4342015-01-06 08:54
回复 2楼 hu9jj
试了,怎么显示成错位了啊
#4
hu9jj2015-01-06 20:25
你原来的一条记录分两行显示的吧,我将其修改成了一行显示。如果错位则再检查一下<td></td>的位置是否合适,再调整一下表格的宽度。

[ 本帖最后由 hu9jj 于 2015-1-6 20:29 编辑 ]
#5
hu9jj2015-01-06 20:31
<TR>
    <TD class=pl23 align=middle width=160 rowSpan=2>
        <A href="showproduct.asp?id=<%=rs("id")%>">
        <IMG height=120 src="<%=rs("photo")%>" width=150 border=0></A>
    </TD>
    <TD class=pla2 style="PADDING-LEFT: 10px; FONT-SIZE: 12px; TEXT-ALIGN: left" height=40>
        <A style="FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #333333" href="showproduct.asp?id=<%=rs("id")%>"> <%=rs("title")%></A>
    </TD>
    <TD class=pl1a style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12px; PADDING-BOTTOM: 10px; LINE-HEIGHT: 22px; PADDING-TOP: 10px" vAlign=top align=left><%=CutStrX(rs("content"),220)%>
   </TD>
   counts=counts-1
   rs.movenext
    <TD class=pl23 align=middle width=160 rowSpan=2>
        <A href="showproduct.asp?id=<%=rs("id")%>">
        <IMG height=120 src="<%=rs("photo")%>" width=150 border=0></A>
    </TD>
    <TD class=pla2 style="PADDING-LEFT: 10px; FONT-SIZE: 12px; TEXT-ALIGN: left" height=40>
        <A style="FONT-WEIGHT: bold; FONT-SIZE: 12px; COLOR: #333333" href="showproduct.asp?id=<%=rs("id")%>"> <%=rs("title")%></A>
    </TD>
    <TD class=pl1a style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; FONT-SIZE: 12px; PADDING-BOTTOM: 10px; LINE-HEIGHT: 22px; PADDING-TOP: 10px" vAlign=top align=left><%=CutStrX(rs("content"),220)%>
   </TD>
</TR>

可能是在发帖编辑时格式出了点问题,请试试这段代码,再适当调整下表格的宽度。

[ 本帖最后由 hu9jj 于 2015-1-6 20:44 编辑 ]
1