$outstanding) { $return_qty = $outstanding; $used_qty = 0; } /* Insert RETURNED row if qty > 0 */ if ($return_qty > 0) { $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`, `status`, `order_no`) VALUES ('$stock_no', '$item_name', '$return_qty', 'RETURNED', '$order_no')" ); } /* Insert USED row if qty > 0 */ if ($used_qty > 0) { $db->query("stock_trans", "INSERT INTO `stock_trans`(`stock_no`, `item_name`, `quantity`, `status`, `order_no`) VALUES ('$stock_no', '$item_name', '$used_qty', 'USED', '$order_no')" ); } $i++; } /* Redirect back so updated outstanding counts are shown immediately */ echo "";