php sql sum类,php数组_sum未添加sqlsrv查询

我正在使用php 5.6&7.0.29执行以下sqlsrv查询,当我得到结果时,我似乎无法使用array_sum添加(sum)“grand_total”的总结果,甚至当我尝试循环它时。

$sql = "SELECT inv_trx.trx_date, datepart(day, datediff(day, 0, inv_trx.trx_date)/7 * 7)/7 + 1 AS WEEKNUMBER , DATEPART(WEEK, DATEADD(MM, DATEDIFF(MM,0,'".$datetime."'), 0))+ 1 AS WEEK_OF_MONTH, inv_trx.trx_qty, inv_trx.unit_price, inv_trx.ord_qty, item.prod_cat, inv_trx.slsman_1, SUM(inv_trx.trx_qty * inv_trx.unit_price) AS grand_total

FROM dbo.customer customer, dbo.inv_trx inv_trx, dbo.item item, dbo.ord_hedr ord_hedr

WHERE datepart(day, datediff(day, 0, inv_trx.trx_date)/7 * 7)/7 + 1 = '1' AND customer.cust_no = inv_trx.cust_no AND customer.cust_no = ord_hedr.cust_no AND inv_trx.order_no = ord_hedr.order_no AND inv_trx.item_no = item.item_no AND

inv_trx.manu_no = item.manu_no AND ((ord_hedr.ord_type='O') AND (inv_trx.trx_type='S') AND (ord_hedr.ord_class<>'M' And ord_hedr.ord_class<>'P') AND (customer.exclude_sa=0) OR (ord_hedr.ord_type='C') AND (inv_trx.trx_type='S') AND (ord_hedr.ord_class<>'M' And ord_hedr.ord_class<>'P') AND (customer.exclude_sa=0)) AND YEAR(inv_trx.trx_date) = '2018' AND MONTH(inv_trx.trx_date) = '7' GROUP BY inv_trx.trx_date, DATEPART(WEEK,inv_trx.trx_date), inv_trx.trx_qty, inv_trx.unit_price, inv_trx.ord_qty, item.prod_cat, inv_trx.slsman_1 ";

$params = array();

$result = sqlsrv_query( $conn, $sql );

if( $result === false) {

die( print_r( sqlsrv_errors(), true) );

}

while( $row = sqlsrv_fetch_array($result, SQLSRV_FETCH_ASSOC) ) {

?>

<?php echo $row['trx_date']->format('m/d/Y')?><?php echo $row['WEEKNUMBER']?><?php echo $row['trx_qty']?><?php echo $row['unit_price']?><?php echo $row['ord_qty']?><?php echo $row['prod_cat']?><?php echo $row['slsman_1']?><?php echo $row['grand_total']?>

$group = array($row['grand_total']);

print_r(array_sum($group));

//echo $row['grand_total']; //result is the same

数组求和的结果是相同的,仅仅是重复了总计本身。

示例:4.8 6 109.4 1.197 17.8 45.5 89,而不是total=184.xx

这是因为我已经在使用SUM来计算总投资额(inv-trx.trx-qty*inv-trx.unit-price)来形成总投资额吗?

我怀疑这是我的数组的问题,但我不确定。任何建议都将不胜感激。

查询生成以下内容

Trx Date Week Trx QTY Price Quantity Category Salesman Total

09/02/2018 1 1 4.8 80 MAG Mickey 4.8

09/02/2018 1 3 2 50 BOB Donald 6

09/02/2018 1 4 27.35 4 POW Goose 109.4

我要做的是得到总数的总和,它是总数。