php - Mysql while 循环累加数字

Question

    $oneweek = date("Y-m-d",strtotime("-1 week"));
    $currentdate = date("Y-m-d");

    $result = mysqli_query($con, "SELECT * FROM `76561198047786230` WHERE date >= '$oneweek' AND date <= '$currentdate'");


 while($row = mysqli_fetch_array($result)) {
            echo $row['start'];
            }



id start  end          date
2   22  23:18   2014-07-03 22:09:16
3   3   03:43   2014-07-04 03:09:10
4   12  13:38   2014-07-04 12:04:19
5   14  16:43   2014-07-04 14:08:53

我的 table 是这样的 ^

当我运行 while 循环时，它将收集这些数据

22
3
12
14

我的问题是，因为它是在循环中执行的，所以它会分别回显出来，所以我如何获取所有这些值并将它们相加，得到 22 + 3 + 12 + 14 = 51？

Answer 1

尝试如下操作:

$count = 0;
while($row = mysqli_fetch_array($result)) 
{
   $count += $row['start'];
}

echo $count; // 51