how i can SUM field values from two or more tables in php mysql

Question

I have six tables with each has two columns named (meal, cost). I can SUM meal of one table. but I want to SUM the total meal of every table.

but like this.i have six tables. and I want to SUM the cost of every table at a time.

$qq="select SUM(cost5) as 'sumcost' from shawon"; 
$res=mysqli_query($conn,$qq); $data=mysqli_fetch_array($res);  
echo "<div class='container'>". "sum of cost: ".$data['sumcost']."</div>";

is there any way to do it?

$qq="select SUM(cost5) as 'sumcost' from shawon"; $res=mysqli_query($conn,$qq); $data=mysqli_fetch_array($res); echo "<div class='container'>". "sum of cost: ".$data['sumcost']."</div>"; i use this code — Sheikh Hasan
– Sheikh Hasan, Commented Jul 29, 2019 at 5:37
Why do you have them as separate tables? If they have the exact same data, can't they be in 1 table? If they must be separate tables, you can sum them separately, union the results together in a subquery and sum that. — Qirel
– Qirel, Commented Jul 29, 2019 at 5:38
Check the answer given below +1, but the need to union six separate tables might be a symptom of poor table design, and that you shouldn't have this data spread across six separate tables. — Tim Biegeleisen
– Tim Biegeleisen, Commented Jul 29, 2019 at 5:45

ScaisEdge · Accepted Answer · 2019-07-29 05:41:22Z

1

You can use union all for buil an unique table with the same column mean, cost form each of six tables

select meal, sum(cost)
from (
  select  meal,cost
  from table1 
  union all 
  select  meal,cost
  from table2
  union all 
  select  meal,cost
  from table3
  union all 
  select  meal,cost
  from table4
  union all 
  select  meal,cost
  from table5
  union all 
  select  meal,cost
  from table6
  ) t 
  group by  meal

answered Jul 29, 2019 at 5:41

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how i can SUM field values from two or more tables in php mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related