newproduct.asp

网络商城系统

<!--#include file="top.asp"-->
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0"> 
<tr> 
  <td width="180" valign="top">
<table width="761" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="FE9ACE">
      <tr> 
        <td width="180" valign="top"><!--#include file="left.asp"--></td>
        <td width="580" valign="top" bgcolor="#FFFFFF"> 
          <table width="2" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
            <tr> 
              <td height="3"></td>
            </tr>
          </table>
          <div align="center"><img src="images/np.gif" width="578" height="24"> 
          </div>
          <table width="575" height="42" border="0" align="center" cellpadding="0" cellspacing="0">
            <tr> 
              <td valign="top"> 
                <%
			set rs=server.createobject("adodb.recordset")
			sql="select top 10 * from goods order by id desc"
			rs.open sql,conn,1,1
			if rs.eof then
			response.write"暂时没有最新商品"
			else
			%>
                <br> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0">
                  <tr> 
                    <%
			  i=0
			do while not rs.eof
			i=i+1
			  %>
                    <td><table width="246" height="80" border="0" cellpadding="0" cellspacing="0">
                        <tr> 
                          <td width="80" height="80" rowspan="4"><a href="goods.asp?id=<%=rs("id")%>"><img class="border3" border="0" src="<%=rs("sp_pic")%>" width="80" height="80"></a></td>
                          <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><font style="text-decoration:underline;color:#FF20AB"><%=rs("sp_name")%></font></a></div></td>
                        </tr>
                        <tr> 
                          <td><div align="center">市场价:<s><%=rs("marprice")%></s>元</div></td>
                        </tr>
                        <tr> 
                          <td><div align="center">会员价:<%=rs("memprice")%>元</div></td>
                        </tr>
                        <tr> 
                          <td><div align="center"><a href="goods.asp?id=<%=rs("id")%>"><img border="0" src="images/look.gif" width="58" height="22"></a></div></td>
                        </tr>
                      </table></td>
                    <%
			if i mod 2=0 then
			%>
                  </tr>
                  <tr>
                    <td height="25"></td>
                  </tr>
                  <%
			  end if
			if i>10 then exit do end if
			rs.movenext
			loop
			%>
                </table>
                <%
			end if
			rs.close
			set rs=nothing
			%>
                <div align="center">本站最新10种商品,欢迎您选购 <br>
                </div></td>
            </tr>
          </table>
          <div align="center"> <br>
          </div></td>
		  
        <td width="4" valign="top"><br>
        </td>
      </tr>
    </table>
    <!--#include file="bottom.asp"-->