info_shopcart.asp

一个ASP做的购物车

<table width="88%" border="0" cellpadding="0" cellspacing="0" align="center" >
<%
if request.cookies("cnhww")("username")<>"" then 
set rs=server.CreateObject("adodb.recordset")
rs.open "select count(*) as rec_count from wq_action where username='"&request.cookies("cnhww")("username")&"' and zhuangtai=7",conn,1,1
rec_count=rs("rec_count")
rs.close
rs.open "select sum(zonger) as zongji from wq_action where username='"&request.cookies("cnhww")("username")&"' and zhuangtai=7",conn,1,1
%>
  <tr>
    <td height="20" align="center"> 有<font color=red><%=rec_count%></font>种商品在购物车内 </td>
    <td height="20" align=center><a href="javascript:;" onClick="javascript:window.open('shopcart.asp?action=show&lx=2','gouwu','width=450,height=350');">查看购物车/结帐</a></td>
    <td height="20" align=center><a href=user.asp?action=favorites>查看我的收藏</a></td>
<%rs.close
 set rs=nothing
else
%>
     <td height="20"></td>
  </tr>
 <%end if%>
</table>