info_tongleituijian.asp

网上购物系统:一个经过完善设计的经典网上购物系统

<table width="100%"  border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td height="143" valign="top">
                        <%
		      sql="select top 6 * from shop_product where btype_id = (select btype_id from shop_product where productid = "&request("id")&") order by productid desc " 
              set rs=server.createobject("adodb.recordset")
		      rs.open sql,conn,1,1
    %>
                        <table width="100%" height="29"  border="0" cellpadding="0" cellspacing="0">
                          <tr>
                            <td class="style4"><img src="img/xiao/view_r_title1.gif" width="191" height="29"></td>
                          </tr>
                        </table>
                        <br>
                        <%do while not rs.eof 
%>
                        <table width="100%"  border="0" cellspacing="0" cellpadding="0">
                          <tr>
                            <td><table width="98%" height="60" border="0" align="center" cellpadding="0" cellspacing="0">
                                <tr>
                                  <td width="76"  height="60">
                                    <TABLE width=65 height=65 border=0 align="center" cellPadding=2 cellSpacing=1 bgColor=#e1e1e1 >
                                      <TBODY>
                                        <TR>
                                          <TD width=65 height=65 bgColor=#ffffff align=center><%if rs("upfilepic")="" then 
response.write "<div align=center><a href=product.asp?id="&rs("productid")&" ><img src=img/emptybook.gif width=65 height=65 border=0></a></div>"
else%>
                                              <a href=product.asp?id=<%=rs("productid")%> ><img src="<%=trim(rs("upfilepic"))%>"  width=60 border=0 height=60></a>
                                              <%end if%>
                                          </td>
                                        </tr>
                                      </tbody>
                                  </table></td>
                                  <td width="111">&#21517;&#31216;:<font color="#ff0000"><%=trim(rs("productname"))%></font><br>
&#20250;&#21592;&#20215;:<font color="#ff0000"><%=trim(rs("huiyuanjia"))%></font></td>
                                </tr>
                            </table></td>
                          </tr>
                          <tr>
                            <td height="10"></td>
                          </tr>
                        </table>
                        <%
rs.movenext
loop
rs.close
end if
%></td>
                    </tr>
                </table>