info_history.asp

一个ASP做的购物车

 <%if request.cookies("cnhww")("username")<>"" or request.cookies("cnhww")("shjianame")<>"" then%>
<table width="178" border=0 cellpadding=0 cellspacing=0>
  <tr> 
    <td background="images/bj_x.gif" height="1"></td>
  </tr>
  <tr>
    <td> 
      <table cellspacing=0 cellpadding=0 height="20">
        <tr> 
          <td><img src="images/main/th_bg.gif" width="178" height="34"></td>
        </tr>
      </table>
    </td>
  </tr>
  <tr>
    <td background="images/bj_x.gif" height="1"></td>
  </tr>
    <tr>
    <td height="3"></td>
  </tr>
</table>
<table width="178" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td height="22" colspan="2"> <b><font color="#FF9900">最近的浏览历史</font></b> </td>
  </tr>
  <%set rs=server.createobject("adodb.recordset")
		    rs.open "select * from wq_his where username='"&request.cookies("cnhww")("username")&"' and lx=1 order by ltime desc",conn,1,1
			while not rs.eof%>
  <tr> 
    <td height="22" align="right" width="19%"> 
      <div align="center"><img src="images/image001.gif"></div>
    </td>
    <td height="22" align="left" width="81%"><a href='list.asp?id=<%=rs("bookid")%>' ><%=rs("bookname")%></a></td>
  </tr>
  <%rs.movenext
		    wend
		    rs.close
		  %>
</table>
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td height="22" colspan="2"> <b><font color="#FF6600">搜索关键词</font></b></td>
  </tr>
  <%set rs=server.createobject("adodb.recordset")
		    rs.open "select * from wq_his where username='"&request.cookies("cnhww")("username")&"' and lx=2 order by ltime desc",conn,1,1
			while not rs.eof%>
  <tr> 
    <td height="22" align="right" width="19%"> 
      <div align="center"><img src="images/image002.gif" width="15" height="15"></div>
    </td>
    <td height="22" align="left" width="81%"><a href='research.asp?<%=rs("searchkey")%>' ><%=rs("bookname")%></a></td>
  </tr>
  <%rs.movenext
		    wend
		    rs.close
			set rs=nothing%>
</table>
<%end if%>