mostsold.asp

购物程序电子商务

<table width=120 height="10" border=0 cellpadding=0 cellspacing=0>
  <tbody>
    <tr> 
      <td valign=top align=middle> 
        <table width="97%" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr> 
            <%set rs=server.CreateObject("adodb.recordset")
		  rs.open "select top 1 id,name,solded,pic,introduce,price1,price2 from product order by solded desc",conn,1,1
		  if rs.eof and rs.bof then
			  response.write "对不起，请您先到商城后台添加商品。"
			  else
			 %>
            <td height="100" align="center"> <a  href=product.asp?id=<%=rs("id")%> target=_blank> 
              <img alt=<%=trim(rs("name"))%> src=<%if trim(rs("pic"))="" then
				  response.write "images/emptybook.gif"
				  else
				  response.write trim(rs("pic"))
				  end if%> border=0></a></td>
          </tr>
          <tr> 
            <td height="30"> <table width="88%" border="0" align="center">
                <tr> 
                  <td> 
                    <% response.write "<a href=product.asp?id="&rs("id")&" target=_blank title=此商品被出售"&rs("solded")&"次>"
				if len(trim(rs("introduce")))>30 then
				response.write left(trim(rs("introduce")),28)&"..."
				else
				response.write trim(rs("introduce"))
				end if
				response.write "</a>"
			  end if%>
                  </td>
                </tr>
              </table></td>
          </tr>
          <tr> 
            <td> <div align="center">市场价：<%=rs("price1")%>元<br>
                会员价：<font color=#FF6600><%=rs("price2")%></font>元</div></td>
          </tr>
          <tr> 
            <td> <div align="center"><a href=# onClick="javascript:window.open('cart.asp?id=<% = rs("id") %>','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"><img src=images/skin/default/cart.gif width=50 height=19 align=absmiddle border=0></a> 
                <a href=# onClick="javascript:window.open('addto.asp?id=<% = rs("id") %>&action=add','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;"><img src=images/skin/default/addto.gif width=50 height=19 align=absmiddle border=0></a> 
                <%  rs.close
			  set rs=nothing %>
              </div></td>
          </tr>
        </table>
      </td>
    </tr>
    <tr> </tr>
  </tbody>
</table>