tejiainfo.asp

商业网站开发有源代码可以运行

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr> 
    <td background="images/bj_x.gif" height="1"> </td>
  </tr>
  <tr>
    <td height="22" bgcolor="EDECEC"> 
      <table cellspacing=0 cellpadding=0 width=170 height="20">
        <tr> 
          <td width=5>&nbsp;</td>
          <td> 
            <div align="center"></div>
             &nbsp;特价商品</td>
          <td width=12>&nbsp;</td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td height="1" background="images/bj_x.gif"></td>
  </tr>
  <tr> 
    <td> 
      <table width="91%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="10"></td>
        </tr>
        <tr> 
          <td height="20"> 
            <%
			set rs=server.CreateObject("adodb.recordset")
			i=0
			rs.open "select top 8 bookid,dazhe,bookname from shop_books where dazhe<=0.6 order by adddate desc",conn,1,1
			if rs.eof and rs.bof then
			response.write "<br>目前没有特价商品"
			end if
			if rs.recordcount>=3 then
			rs.absoluteposition=3
			do while not rs.eof
			i=i+1
			if len(trim(rs("bookname")))>11 then
			response.write "·<a href=list.asp?id="&rs("bookid")&" target=_blank>"&left(trim(rs("bookname")),11)&"...</a></font><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td background=images/bj_x1.gif height=1></td></tr></table><br>"
			else
			response.write "·<a href=list.asp?id="&rs("bookid")&" target=_blank>"&trim(rs("bookname"))&"</a><table width=100% border=0 cellspacing=0 cellpadding=0><tr><td background=images/bj_x1.gif height=1></td></tr></table><br>"
			end if
			if i>=6 then exit do
			rs.movenext
			loop
			end if
			rs.close
			set rs=nothing
			%>
          </td>
        </tr>
        <tr> 
          <td></td>
        </tr>
        <tr> 
          <td height="1"></td>
        </tr>
        <tr> 
          <td height="1"></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr> 
    <td>&nbsp;</td>
  </tr>
</table>