Subtotals using PHP?

[Mike-2003]

I have the below code which produces the sample I have listed, but I would like to subtotal by Zone, Employee and give a grand total at the end. I thought I have seen this done before, but can't remember where.

Any help would be appreciated.
Thanks,
Mike
Sample:
Zone Employee Name Lines Pieces
LW Smith,Joe 80 163
UP Smith,Joe 80 163
UP Smith,Joe 80 163
UP Smith2,Joe 141 203
UP Smith2,Joe 86 458

Code:

if (($result = dosql($sql)) && (mysql_num_rows($result))) {

echo "<table width=100% bgcolor='" . $color . "' class='reportsborder' cellspacing=1 cellpadding=1>";
echo "<tr valign='top' align='left'>";
echo "<table width=100%><tr bgcolor='#ffffff'><td class='text9bold' width=2% align = 'left'>&nbsp</td>";
echo "<td class='text9bold' width=5% align='center'>Zone</td>";
echo "<td class='text9bold' width=10% align='center'>Employee Name</td>";
echo "<td class='text9bold' width=5% align='center'>Lines</td>";
echo "<td class='text9bold' width=5% align='center'>Pieces</td>";
echo "</tr></table>";
	while ($query_data = mysql_fetch_array($result)) {
		If ($prev_emp_name <> $query_data["EmployeeFull"] and $rec_ct <> 0) {

echo "<table width=100% bgcolor='#ffffff' cellspacing=1 cellpadding=1>";
echo "<tr valign='top' align='left' bgcolor='#ffffff'><td>&nbsp</td></tr></table>";

} else {
//no change
				}

echo "<table width=100% bgcolor='" . $color . "' class='reportsborder' cellspacing=1 cellpadding=1>";
echo "<tr valign='top' align='left'>";
echo "<td class='text9' width=5% align='center'>".$query_data["Zone"]."</td>";
echo "<td class='text9' width=10% align='center'>".$query_data["LastName"].",".$query_data["FirstName"]."</td>";
echo "<td class='text9' width=5% align='center'>".$query_data["BatchLines"]."</td>";
echo "<td class='text9' width=5% align='center'>".$query_data["BatchPieces"]."</td>";
echo "</tr>";
echo "</table>";

if ($color == "#eeffee") $color = "#ffffff";
else $color = "#eeffee";

	}   

}
	else {
echo "No Carts recorded in date range";

}

[bubblenut]

In the while loop

if(isset($zonesubtot[$query_data['Zone']])) {
  $zonelinessub[$query_data['zone']]+=(int)$query_data['zone'];
} else {
  $zonelinessub[$query_date['zone']]=(int)$query_data['zone'];
}

Where you want to display the zone-line subtotals

<table>
  <thead>
    <th>Zone</th>
    <th>Sub-total</th>
  </thead>
<?php
foreach($zonelinessub as $key => $value) {
?>
  <tr>
    <td><?php echo($key);?></td>
    <td><?php echo($value);?></td>
  </tr>
<?php
}
?>
</table>

HTH
Bubble

[Mike-2003]

On the zone line totals, if I wanted to have it do the folllowing:

Zone Employee Name Lines Pieces
LW Smith,Joe 80 163
total zone 80 163
UP Smith,Joe 80 163
UP Smith,Joe 80 163
total zone 160 326

I'm not sure where I would put the foreach statement in my code for reporting.
Thanks

[Mike-2003]

I tried putting the foreach statement at the bottom and it comes up with error :

Warning: Invalid argument supplied for foreach() in line 190

Did I miss something?

Thanks,
Mike