<table width="88%" border="0" cellpadding="0" cellspacing="0" align="center" >
<%
if request.cookies("shopzhiwang")("username")<>"" then 
set rs=server.CreateObject("adodb.recordset")
rs.open "select count(*) as rec_count from sh_action where username='"&request.cookies("shopzhiwang")("username")&"' and zhuangtai=7",conn,1,1
rec_count=rs("rec_count")
rs.close
rs.open "select sum(zonger) as zongji from sh_action where username='"&request.cookies("shopzhiwang")("username")&"' and zhuangtai=7",conn,1,1
%>
  <tr>
    <td height="20" align="center"> 有<font color=red><%=rec_count%></font>種商品在購(gòu)物車(chē)內(nèi) </td>
    <td height="20" align=center><a href="javascript:;" onClick="javascript:window.open('shopcart.asp?action=show&lx=2','gouwu','width=600,height=600');">查看購(gòu)物車(chē)/結(jié)帳</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>