获取每行的值

Question

In my mysql tables I have for example a row that holds values, lets call this table "days" and the row "haircuts".

So I have 5 rows all with "1","2","3","4","5" under "haircuts". What I want to do, in php, is add them all together and echo. So it would maybe look like this:

echo "Total haircuts: ",$haircuts;

Which would hopefully show:

Total haircuts: 15

I can't figure out how, though. Here's how I'm currently doing it.

$getstats = mysqli_query($con,"SELECT * FROM stats");
$gotstats = mysqli_fetch_array($getstats);
$haircuts = $gotstats['haircuts'];

But it only echoes the "haircuts" of the first row? :(

I have multiple columns I would like to total and echo too if that is possible?

Answer 1

You probably should use MySQL SUM().

SELECT SUM(haircuts) as tot_cuts FROM stats;

$gotstats['tot_cuts'];