$subtotal = 0; $total = 0; while ($row = mysql_fetch_assoc($result3)) { $tax_percent_of_item = $row['item_tax_percent']; if ($tax_percent == $tax_percent_of_item) { if ($rowCounter % 2 == 0) { echo "\n<tr bgcolor={$display->rowcolor1}>\n"; } else { echo "\n<tr bgcolor={$display->rowcolor2}>\n"; } $rowCounter++; for ($k = 0; $k < count($tablefields); $k++) { $field = $tablefields[$k]; if ($field == 'brand_id' or $field == 'category_id' or $field == 'supplier_id') { $field_data = $display->idToField("{$cfg_tableprefix}" . 'items', "{$field}", $row['item_id']); $data = $display->formatData($field, $field_data, $cfg_tableprefix); } else { $data = $display->formatData($field, $row[$field], $cfg_tableprefix); } echo "\n<td align='center'>\n<font color='{$display->rowcolor_text}' face='{$display->rowfont_face}' size='{$display->rowfont_size}'>{$data}</font>\n</td>\n"; } @($subtotal += $row['item_total_cost'] - $row['item_total_tax']); @($total += $row['item_total_cost']); } } echo '</table>' . "\n"; $subtotal = number_format($subtotal, 2, '.', ''); $total = number_format($total, 2, '.', ''); $tax = $total - $subtotal; $tax = number_format($tax, 2, '.', ''); echo "<br><table align='right' cellspacing='{$display->cellspacing}' cellpadding='{$display->cellpadding}' bgcolor='{$display->table_bgcolor}' width='60%' border=0>";