Asp,Php,Jssdk,mysql,mssql,微信公众号开发,小程序开发-学习笔记

<% = Conn.Execute("select count(dlsid) from [member] where dlsid='"&newdlshyid&"'")(0) %> 人

会员人数：<% = Conn.Execute("select count(dlsid) from [member] where dlsid='"&newdlshyid&"'")(0) %>

会员帐户：<% = Conn.Execute("SELECT SUM(rmb) FROM [member] where dlsid='"&newdlshyid&"'")(0) %> 元

流水：<% = Conn.Execute("select count(id) from [ancoset] where dlsid='"&newdlshyid&"'")(0) %> 笔

=========================

商家数量：<% = Conn.Execute("select count(id) from [dls]")(0) %> 家

会员人数：<% = Conn.Execute("select count(id) from [member]")(0) %> 人

商家总额：<% = Conn.Execute("SELECT SUM(rmb) FROM [dls]")(0) %> 元

会员总额：<% = Conn.Execute("SELECT SUM(rmb) FROM [member]")(0) %> 元

流水明细：<% = Conn.Execute("select count(id) from [ancoset]")(0) %> 笔

【已报名】<% bmrs = Conn.Execute("SELECT SUM(crsl+etsl) FROM [baoming] where yid="&bm_yid&"")(0):response.Write(bmrs) %> 人