Sum of calculated column in foreach

Question

I have a mysql table

service_charges

id service_name service_charges 

I am using mysql query like

 select service_name service, service_charges,count(service_name)as unit from service charges group_by service 

in php file I use

 foreach(services as service){ echo $service['service']; echo $service['service_charges']; echo $service['unit']; $service_charges_total = (($service['service_charges'])*($service['unit'])); echo $sevice_charges_total; } 

I get the result as follows:

Now How can I get the total value for $ service_charges_total (quantity column), i.e. I want a total of 4200 + 1200 + 350 = 5750.

Thanks.

Answer 1

You can do it in php with your function like this

 $total=0; foreach(services as service) { echo $service['service']; echo $service['service_charges']; echo $service['unit']; $service_charges_total = (($service['service_charges'])*($service['unit'])); echo $sevice_charges_total; $total+=$sevice_charges_total; } echo $total; 

Answer 2

 select service_name as service, service_charges, count(service_name) as unit, (select sum(service_charges) from service) as total_amount from service as charges group_by service, service_charges 

Answer 3

 SELECT sum(Amount) from service_charges; 

Answer 4

I hope this work is for you

Store the sum value in an array and then use array_sum ()

 $service_charges_total = (($service['service_charges'])*($service['unit'])); $array[]=$service_charges_total; $total_sum=array_sum($array); echo $total_sum;