在PHP中获取SUM以获取数据库值[关闭]

Question

How could I get sum value in php file

$a = mysql_query('SELECT d.name, d.idnumber, d.days FROM users d');
while($row = mysql_fetch_array($a))
{
   $idnumber = $row['idnumber'];
   $days     = $row['days'];
   echo $array_sum($days); 
}

I need to sum the variable that I got from database in php file, but not as SUM in the query. In my database I Have 3 rows i.e., 3, 10 and 1. So I need 14 as sum

Answer 1

$sum = 0;
$a = mysql_query('SELECT d.name, d.idnumber, d.days FROM users d');
while($row = mysql_fetch_array($a))
{
   $idnumber = $row['idnumber'];
   $days     = $row['days'];
   $sum     += intval($days);
}
echo $sum;