本文由 千趣源码 – qianqu 发布，转载请注明出处，如有问题请联系我们！group中sum的值如何获取?Tp5-Mysql-PHP
group-sum如何获取多条数据的sum值。
->field('sum(wareqty) as wareqty,wareid')
之后获取的数据就会是以wareid来区分去重后统计到的sum值如下图
[0] => array(3) {
["wareqty"] => string(8) "3.000000"
["wareid"] => string(6) "107695"
["ROW_NUMBER"] => string(1) "1"
}
[1] => array(3) {
["wareqty"] => string(9) "12.000000"
["wareid"] => string(6) "107539"
["ROW_NUMBER"] => string(1) "2"
}
[2] => array(3) {
["wareqty"] => string(8) "5.000000"
["wareid"] => string(6) "101401"
["ROW_NUMBER"] => string(1) "3"
}
[3] => array(3) {
["wareqty"] => string(8) "4.000000"
["wareid"] => string(6) "107106"
["ROW_NUMBER"] => string(1) "4"
} 点赞(0)
