|
|
<%
dim joindtm,deposit,myorder,successed,successedsum,lastorder
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [user] where username='"&request.cookies("timesshop")("username")&"'",conn,1,1
joindtm=rs("adddate")
deposit=rs("deposit")
rs.close
rs.open "select * from goods where username='"&request.cookies("timesshop")("username")&"' and mdel=0 ",conn,1,1
if rs.eof and rs.bof then
response.write ""
else
rs.movelast
lastorder=rs("dcreatedate")
myorder=rs.recordcount
end if
rs.close
rs.open "select count(totaljg) as totaljg from goods where username='"&request.cookies("timesshop")("username")&"' and goodsstats=2 ",conn,1,1
if rs("totaljg")>0 then
successedsum=rs("totaljg")
else
successedsum=0
end if
rs.close
rs.open "select * from goods where username='"&request.cookies("timesshop")("username")&"' and goodsstats=2 and mdel=0",conn,1,1
successed=rs.recordcount
set rs=nothing %>
| 以下是您在本站的一些历史记录的统计信息 |
|
| 注册日期： | <% =joindtm %> |
| 上次下单： | <% =lastorder %> |
| 下单次数： | <% = myorder %>次 |
| 成交次数： | <% =successed %>次 |
| 成交金额： | <% =successedsum %>元 |
| 预 存 款： | <% =deposit %>元 |
|
|
.gif){kind=small}
会员统计信息 .gif){kind=small}