$field_data = array("{$saleID}", "{$temp_item_id}", "{$temp_quantity_purchased}", "{$temp_item_unit_price}", "{$temp_item_buy_price}", "{$temp_item_tax_percent}", "{$temp_item_tax}", "{$temp_item_cost}"); $new_quantity = $dbf->idToField($items_table, 'quantity', $temp_item_id) - $temp_quantity_purchased; $query = "UPDATE {$items_table} SET quantity=\"{$new_quantity}\" WHERE {$temp_item_id}=id"; mysql_query($query, $dbf->conn); $dbf->insert($field_names, $field_data, $sales_items_table, false); echo "<tr><td align='center'><font color='white'>{$temp_item_name}</font></td>\n\t\t\t <td align='center'><font color='white'>{$cfg_currency_symbol}{$temp_item_unit_price}</font></td>\n\t\t\t <td align='center'><font color='white'>{$temp_quantity_purchased}</font></td>\n\t\t\t <td align='center'><font color='white'>{$cfg_currency_symbol}{$temp_item_cost}</font></td>\n\t\t </tr>"; } echo "</table><br>\n<table border='0' align='center'><tr><td><b>{$lang->saleSubTotal}: {$cfg_currency_symbol}{$subtotal}</b></td></tr>"; echo "<tr><td><b>{$lang->tax}: {$cfg_currency_symbol}{$final_tax}</b></td></tr>"; echo "<tr><td><b>{$lang->saleTotalCost}: {$cfg_currency_symbol}{$sale_total_cost}</b></td></tr>"; if ($amt_tendered != 0) { echo "<tr><td><b>{$lang->amtTendered}: {$cfg_currency_symbol}{$amt_tendered}</b></td></tr>"; echo "<tr><td><br/><b>{$lang->amtChange}: {$cfg_currency_symbol}{$amt_change}</b><br/></td></tr>"; } echo "<tr><td><b>{$lang->saleID}: {$saleID}</b></td></tr></table></table>"; $sec->closeSale(); $dbf->closeDBlink(); echo "<br><br><b>{$lang->contact} {$cfg_company}:</b><p>"; if ($cfg_address != '') { $temp_address = nl2br($cfg_address); echo "{$lang->address}: {$temp_address} <br>"; } if ($cfg_phone != '') { echo "{$lang->phoneNumber}: {$cfg_phone} <br>"; } if ($cfg_email != '') { echo "{$lang->email}: {$cfg_email} <br>"; } if ($cfg_fax != '') { echo "{$lang->fax}: {$cfg_fax} <br>"; }