php array doesn't sum numbers -

php array doesn't sum numbers -

why doesn't code sum spent_hours each user?

while ($row = $result->fetch_assoc()) { $total_spent_time += $row['spent_time']; if (!array_key_exists($row['activity_type'], $data)) { $data[$row['activity_type']] = array( 'spent_time' => array('user' => array()) ); $data[$row['activity_type']]['spent_time']['user'][$row['user']] = array('time' => $row['spent_time']); if (array_key_exists($row['user'], $data[$row['activity_type']]['spent_time']['user'])) { $data[$row['activity_type']]['spent_time']['user'][$row['user']]['time'] += $row['spent_time']; } }

it gives me lastly value of row.

try declare counter before loop:

$total_spent_time = 0; while ($row = $result->fetch_assoc()) { $total_spent_time += $row['spent_time']; } echo $total_spent_time;

php arrays sum