<?php $sql = "select Rev_lx,cout(Rev_lx) as Rev_count,sum(Rev_kmoney) as Rev_money from guahao_table group by Rev_lx"; $query = mysql_query($sql); $count = 0; $money = 0; while($v = mysql_fetch_array($query)){ $count += $v['Rev_count']; $money += $v['Rev_money']; $sub[$v['Rev_lx']]=$v; } echo "统计结果:共有{$count}个人挂号,共{$money}元,其中普号:{$sub['puhao']['Rev_count']}人,共{$sub['puhao']['Rev_money']}元,急症共{$sub['jizheng']['Rev_count']}人,共{$sub['jizheng']['Rev_money']}元"; 没测试,不知道行不行 数据库也没有连接,只是写了查询部分
有笔误 "select Rev_lx,cout(Rev_lx) as Rev_count,sum(Rev_kmoney) as Rev_money from guahao_table group by Rev_lx";cout!=count"select Rev_lx,count(Rev_lx) as Rev_count,sum(Rev_kmoney) as Rev_money from guahao_table group by Rev_lx";
<?php
$sql = "select Rev_lx,cout(Rev_lx) as Rev_count,sum(Rev_kmoney) as Rev_money from guahao_table group by Rev_lx";
$query = mysql_query($sql);
$count = 0;
$money = 0;
while($v = mysql_fetch_array($query)){
$count += $v['Rev_count'];
$money += $v['Rev_money'];
$sub[$v['Rev_lx']]=$v;
}
echo "统计结果:共有{$count}个人挂号,共{$money}元,其中普号:{$sub['puhao']['Rev_count']}人,共{$sub['puhao']['Rev_money']}元,急症共{$sub['jizheng']['Rev_count']}人,共{$sub['jizheng']['Rev_money']}元";
没测试,不知道行不行
数据库也没有连接,只是写了查询部分
"select Rev_lx,cout(Rev_lx) as Rev_count,sum(Rev_kmoney) as Rev_money from guahao_table group by Rev_lx";cout!=count"select Rev_lx,count(Rev_lx) as Rev_count,sum(Rev_kmoney) as Rev_money from guahao_table group by Rev_lx";