shopxp_tj.asp

IMPORTANT YOU SHOUD LOAD IT DOWN FOR USING

<!--首页的特价商品-->
<style type="text/css">
<!--
.style4 {color: #FF0000}
-->
</style>
<table width="99%"  border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><img src="shopxp_images/shopxp<%=BoardStyle%>/new_title_002.gif" height="36"></td>
  </tr>
</table>
<table width="200" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="20">&nbsp;</td>
    <td width="190"><table width="905" border="0" align="center" cellpadding="0" cellspacing="0">
      <tbody>
        <tr>
          <td valign="top" width="4" height="4"><img height="4" 
            src="img_shopxp/xiao/new_line_004.gif" width="4" /></td>
          <td background="img_shopxp/xiao/new_line_008.gif" height="4"></td>
          <td valign="top" width="4" height="4"><img height="4" 
            src="img_shopxp/xiao/new_line_005.gif" width="4" /></td>
        </tr>
        <tr>
          <td width="1" background="img_shopxp/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 "&tejia&" * from shopxp_product where shopxp_tejia_pt=1 order by shopxpptid 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="110" height="130"  border="0" cellpadding="0" cellspacing="0">
                    <tr>
                      <td width="110" height="95"><div align="center">
                        <table width="90" height="90" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#e1e1e1">
                          <tbody>
                            <tr>
                              <td width="90" height="90" bgcolor="#ffffff" align="center"><a href="productshopxp.asp?id=<%=rs("shopxpptid")%>" target="_blank"><img src="<%=trim(rs("upfilepic"))%>" alt="<%=rs("shopxpptname")%>"  width="<% = xtk %>"  height="<% = xtg %>" border="0" /></a></td>
                            </tr>
                          </tbody>
                        </table>
                      </div></td>
                    </tr>
                    <tr>
                      <td height="23" valign="middle"><div align="center"><a href="productshopxp.asp?id=<%=rs("shopxpptid")%>" target="_blank"><font color="#FF0000"><%=trim(rs("shopxpptname"))%></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("shopxphyjia"))%> 元</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_shopxp/xiao/new_line_010.gif"></td>
        </tr>
        <tr>
          <td valign="top" width="4" height="4"><img height="4" 
            src="img_shopxp/xiao/new_line_006.gif" width="4" /></td>
          <td background="img_shopxp/xiao/new_line_011.gif"></td>
          <td valign="top" width="4" height="4"><img height="4" 
            src="img_shopxp/xiao/new_line_007.gif" width="4" /></td>
        </tr>
      </tbody>
    </table></td>
  </tr>
</table>