gouwucheinfo.asp

网趣购物系统加强升级版 ○ 完美整合BBS论坛程序

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="33"><img src="image/myshop.gif" width="178"></td>
</tr>
<tr> 
<td> 
<table width="100%" border="0" cellpadding="0" cellspacing="0" align="center" height="109">
<%
	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="2" align=cneter></td>
</tr>
<tr> 
<td height="20">　您的购物车有<font color=red><%=rec_count%></font>件商品 
</td>
</tr>
<tr> 
<td height="20">　总金额：<font color=red><%=rs("zongji")%></font>元 
</td>
</tr>
<tr> 
<td height="20">　<a href="gouwu.asp?action=show&lx=1" target=_blank>查看购物车/结帐&gt;&gt;</a></td>
</tr>
<tr> 
<td height="20">　<a href=user.asp?action=shoucang>我的收藏&gt;&gt;</a></td>
</tr>
<%rs.close
		set rs=nothing
		else%>
<tr> 
<td height="20"> 
　您的购物车有<font color=red>0</font>件商品<br>
　总金额：<font color=red>0</font>元
</td>
</tr>
<tr> 
<td height="1"></td>
</tr>
<%end if%>
</table>
</td>
</tr>
</table>