info_history1.asp

网上购物,不错的购物系统,花了好长时间来改的

<%if request.cookies("shopzhiwang")("username")<>"" or request.cookies("shopzhiwang")("shjianame")<>"" then%>
<table width="100%" 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 top 2 * from sh_his where username='"&request.cookies("shopzhiwang")("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
			set rs=nothing
		  %>
</table>
<table width="100%" 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 top 2 * from sh_his where username='"&request.cookies("shopzhiwang")("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>
<%

else
%>
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center"><font color="#006600">您登陆之后就可以查看</font></td>
  </tr>
  <tr>
    <td><b><font color="#FF9900"><img src="images/book_15.gif" width="33" height="20">最近的浏览历史</font></b></td>
  </tr>
  <tr>
    <td><b><font color="#FF6600"><img src="images/book_14.gif" width="33" height="20">最近搜索关键词</font></b></td>
  </tr>
</table>


<%end if%>