Totaling an Array

[az_wraith]

I have the following that I would like to do. The current code that I have totals the indivisiual averages. What I would like to do is also add total from the indivisuals.

	$result = mysql_query("SELECT * FROM ".$_CONF['conn']."layer WHERE did = '$thisdid' AND layerid = $lid"); 
	if(!$result) { echo mysql_errno().": ".mysql_error()."<br>"; }
	$scount = mysql_numrows($result);
	$sc = 0;
	$p_array = Array();
	while($sc < $scount) {
		$layerid = mysql_result($result,$sc,"layerid");
			$p_array[$layerid][lid] = $layerid;
      $p_array[$layerid][layer] = $p_array[$layerid][layer] + mysql_result($result,$sc,"layer");
      $p_array[$layerid][one] = $p_array[$layerid][one] + mysql_result($result,$sc,"one");
      $p_array[$layerid][two] = $p_array[$layerid][two] + mysql_result($result,$sc,"two");
      $p_array[$layerid][thr] = $p_array[$layerid][thr] + mysql_result($result,$sc,"thr");
      $p_array[$layerid][fou] = $p_array[$layerid][fou] + mysql_result($result,$sc,"fou");
      $p_array[$layerid][total] = $p_array[$layerid][one] + $p_array[$layerid][two] + $p_array[$layerid][thr] + $p_array[$layerid][fou];
      $p_array[$layerid][average] = round($p_array[$layerid][total] / $p_array[$layerid][layer]);
		$sc++;
	}
	foreach ($p_array as $key => $value) {
		$layer_average = $value["average"];
	}

That prints

43
30
40
46
44

I would like to total all that up.

[bradgrafelman]

I don't see how that code will output any such data, as there is no echo() statement other than the one in the if() statement that outputs error messages.

So, I'll assume that the numbers you want to sum up are in the foreach() loop at the bottom. Thus, you can replace this:

    foreach ($p_array as $key => $value) {
        $layer_average = $value["average"];
    } 

with this:

    $total = 0;
    foreach ($p_array as $key => $value) {
        $total += $layer_average = $value["average"];
    }
    echo "Total: $total";