mysql:
select sum(value1) as total1,sum(value2) as total2 from table;
thinkphp:
$Useracounttotal = M('Commission')->where(array('userid'=>$userInfo['id'],'status'=>1))->field('sum(commissions) as commission')->find();
mysql:
select sum(value1) as total1,sum(value2) as total2 from table;
thinkphp:
$Useracounttotal = M('Commission')->where(array('userid'=>$userInfo['id'],'status'=>1))->field('sum(commissions) as commission')->find();