newbooks.asp

一个免费的绿叶网上书店请大家提宝贵意见 站长的帐号是 用户名：雨丁香 密码：200505 副站长帐号是 用户名： wangli 密码：197207

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="../include/top.asp"-->
<table width="778" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="210" height="24" background="../images/bg2.gif"> <div align="center"><strong></strong></div></td>
    <td width="568" rowspan="18" valign="bottom"> <% 
	sql="select id,bookname,price,memprice,picture,publish from books where new=true order by id desc"
	rs.open sql,conn,1
	%> <!--#include file="../include/pages.inc"--> <table border="0" cellpadding="0" cellspacing="0" width="537">
        <% for i=1 to rs.pagesize
     if rs.eof then exit for
        sheng=rs("price")-rs("memprice")%>
        <tr> 
          <td width="114" rowspan="4"><div align="center"><img src="../spacer.gif" width="1" height="113" border="0" alt=""><a href="booklist.asp?id=<%=rs("id")%>"><img src="../admin/<%=rs("picture")%>" width="85" height="104" border="0"></a></div></td>
          <td width="86" height="31"> <div align="center"><font color="#000000" size="2">图书名称：</font></div></td>
          <td width="337"><font size="2"><a href="booklist.asp?id=<%=rs("id")%>" class="text2"><%=rs("bookname")%></a></font></td>
        </tr>
        <tr> 
          <td height="29"> <div align="center"><font color="#000000" size="2">出版社：</font></div></td>
          <td><font size="2"><%=rs("publish")%></font></td>
        </tr>
        <tr> 
          <td height="29"> <div align="center"><font size="2">市场价：</font></div></td>
          <td><font size="2"><span class="delt"><%=rs("price")%></span>元　　会员价：<%=rs("memprice")%>元　　节省：<%=sheng%>元</font></td>
        </tr>
        <tr> 
          <td height="21">&nbsp;</td>
          <td><font size="2"><a href="booklist.asp?id=<%=rs("id")%>" class="text2">详细资料</a> 
            </font></td>
        </tr>
        <tr> 
          <td height="4" colspan="3"><img src="../images/LINE11.gif" width="420" height="1"></td>
        </tr>
        <% 
		  rs.movenext
		next
		  %>
      </table>
      <br> <% call ShowPageNavigator(pageno,"newbooks.asp")%> </td>
  </tr>
  <% rs.close %>
  <!--#include file="../include/left.htm"-->
  <tr>
    <td background="../images/bg2.gif">&nbsp;</td>
  </tr>
</table>
<!--#include file="../include/foot.asp"-->