<?php include('config.php'); $payid = $_POST['payid']; $invdate = $_POST['invdate']; $payingamt = $_POST['payingamt']; $invamt = $_POST['invamt']; $currency = $_POST['currency']; $remarks = $_POST['remarks']; $balance = $invamt - $payingamt; $sqls = $js->prepare('UPDATE invoicepayments SET paydate = :invdate, payamount = :payingamt, currency = :currency, balance = :balance, remarks = :remarks WHERE id = :payid '); $status = $sqls->execute(array(':invdate' => $invdate, ':payingamt' => $payingamt, ':currency' => $currency, ':balance' => $balance, ':remarks' => $remarks, ':payid' => $payid)); ?> <script type="text/javascript"> alert("Have Successfully Updated The Invoice Payment"); window.location = "invoicepayments.php"; </script>