php多层循环中求和

Question

$chaxun = mysqli_query($jc, 'SELECT * FROM lrr_quyu WHERE quyu=1');//在基础数据库里面查询出1区域有多少个门店
while($qyrow = mysqli_fetch_array($chaxun )){
$qyorgname = $qyrow['orgname']; //查询出区域里面有这么多门店
$chaxun1 = mysqli_query($saoma, 'SELECT jine FROM lrr_quyu WHERE bouss='$qyorgname'');//根据查询到的门店查询当日的金额.注意两个不是一个数据库
$tongji=mysqli_num_rows($chaxun1);//查询结果多少条
echo“$tongji”;
}

现在想要的是1区所有门店的条数总和，这种的应该怎么查询

Answer 1

$chaxun = mysqli_query($jc, 'SELECT * FROM lrr_quyu WHERE quyu=1');//在基础数据库里面查询出1区域有多少个门店
$tongji=0;//放循环外
while($qyrow = mysqli_fetch_array($chaxun )){
$qyorgname = $qyrow['orgname']; //查询出区域里面有这么多门店
$chaxun1 = mysqli_query($saoma, 'SELECT jine FROM lrr_quyu WHERE bouss='$qyorgname'');//根据查询到的门店查询当日的金额.注意两个不是一个数据库
$tongji+=mysqli_num_rows($chaxun1);//查询结果多少条，累加
//echo“$tongji”;
}
echo "$tongji";