info_tj.asp

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

<!--首页的特价商品-->
<style type="text/css">
<!--
.style4 {color: #FF0000}
-->
</style>
<table width="99%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><img src="img/xiao/new_title_002.gif" width="800" height="36"></td>
  </tr>
</table>
<TABLE width=99% border=0 align="center" cellPadding=0 cellSpacing=0>
  <TBODY>
    <TR>
      <TD vAlign=top width=4 height=4><IMG height=4 
            src="img/xiao/new_line_004.gif" width=4></TD>
      <TD background=img/xiao/new_line_008.gif height=4></TD>
      <TD vAlign=top width=4 height=4><IMG height=4 
            src="img/xiao/new_line_005.gif" width=4></TD>
    </TR>
    <TR>
      <TD width="1" background=img/xiao/new_line_009.gif></TD>
      <TD 
          style="PADDING-RIGHT: 0px; PADDING-LEFT: 0px; PADDING-BOTTOM: 3px; PADDING-TOP: 0px" 
          align=middle><table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <%set rs=server.CreateObject("adodb.recordset")
		  rs.open "select Top 14 * from shop_product where tejiaproduct=1 order by productid desc ",conn,1,1
		  if rs.eof and rs.bof then
		  response.write "目前还没有特价商品"
		  'response.End
		  else
		  %>
          <%
		if not rs.eof then
		i=1
		do while not rs.eof%>
          <td width="565" height="154" valign="top"><table width="98" height="130"  border="0" align="center" cellpadding="0" cellspacing="0">
              <tr>
                <td width="100" height="100"><div align="center">
                  <table width="100" height="100" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#e1e1e1">
                    <tbody>
                      <tr>
                        <td width="100" height="100" align="center" valign="middle" bgcolor="#ffffff"><div align="center"><a href="product.asp?id=<%=rs("productid")%>" target="_blank"><img src="<%=trim(rs("upfilepic"))%>" alt="<%=rs("productname")%>" width="100" height="100" border="0" /></a></div></td>
                      </tr>
                    </tbody>
                  </table>
                </div></td>
              </tr>
              <tr>
                <td height="23" valign="middle"><div align="center"><a href=product.asp?id=<%=rs("productid")%> target="_blank"><font color="#FF0000"><%=trim(rs("productname"))%></font></a></div></td>
              </tr>
              <tr>
                <td height="13" valign="bottom"><table width="98%"  border="0" cellspacing="0" cellpadding="0">
                    <tr>
                      <td height="37"><div align="center"> <font color="#999999"><s>市场价：<%=trim(rs("shichangjia"))%> 元</s></font><br>
                              <span class="style4">会员价：<%=trim(rs("huiyuanjia"))%> 元</span> </div></td>
                    </tr>
                </table></td>
              </tr>
          </table></td>
          <%if i mod 7 = 0 then%>
        </tr>
        <%end if
	    rs.movenext
         i=i+1
    	 loop
		rs.close
		end if
		end if 
	%>
      </table></TD>
      <TD width="1" background=img/xiao/new_line_010.gif></TD>
    </TR>
    <TR>
      <TD vAlign=top width=4 height=4><IMG height=4 
            src="img/xiao/new_line_006.gif" width=4></TD>
      <TD background=img/xiao/new_line_011.gif></TD>
      <TD vAlign=top width=4 height=4><IMG height=4 
            src="img/xiao/new_line_007.gif" width=4></TD>
    </TR>
  </TBODY>
</TABLE>