[RESOLVED] sum one array element

Kurtismonger

I have an array that contains two elements partNo and Quantity. I want to sum the quantity element for all values in the array. From what I can tell array_sum() sums all elements and converts non-numeric fields to their number equivalent or something...whatever it does I don't get a good total.
I'm sure there is an easy solution but I'm hitting a wall.

NogDog

If we're talking about something like:

$array = array(
   0 => array(
      'partNo' => 12345,
      'Quantity' => 1
   ),
   1 => array(
      'partNo' => 23456,
      'Quantity' => 3
   )
);

Then you could do:

$total = 0;
foreach($array as $item)
{
   $total += $item['Quantity'];
}
echo "Total is: $total";

Kurtismonger

That doesn't quite work. Here is my code:

$sql = "SELECT Production.PartNo AS Part,
		Production.QuantProd AS Quantity
		FROM Production
		WHERE $deptString
			AND Production.ProdDate >=$startDate
			AND Production.ProdDate <=$endDate";

$result = mysql_query($sql);
while ($resultArray = mysql_fetch_array($result)) {
echo $resultArray["Part"];
echo $resultArray["Quantity"];
echo '<br />';
}

This shows me the correct total for each part number. What I want is a grand total of those parts. When I add the code suggested by NogDog I get a incorrect total.

NogDog

$total = 0;
while ($resultArray = mysql_fetch_array($result)) {
   $total += $resultArray["Quantity"];
   echo $resultArray["Part"];
   echo $resultArray["Quantity"];
   echo '<br />';
}
echo "Total: $total";

Kurtismonger

Thanks NogDog, thats it exactly. Knew I would kick myself when I saw the solution.