获取while循环中添加的每一行的总和

Question

So I have a mysql table that contains an integer in each row. What I am trying to do is get the sum of the integers. Here is what I currently have that is working.

$cn = 0;
$sql = mysqli_query($con,"SELECT * FROM members WHERE member='$userid'");
while($row = mysqli_fetch_array($sql)) {
$i = $row['number'];

$cn = $cn + $i;
}

echo $cn;

So I make $cn equal zero then each time it goes through the loop it will add the number from the matching row.

Does anyone have a better idea on how to accomplish this? Thanks!

Answer 1

You don't need to use PHP or here a loop for that, because your database can do the job for you.

$sql = mysqli_query($con,"SELECT sum(number) FROM members WHERE member='$userid'");