<?php include('config.php'); $cid = $_GET['cid']; $stats = 'Finished'; $sql1 = $js->prepare('UPDATE customer_entry SET enquirystatus = :stats WHERE id = :cid'); $status1 = $sql1->execute(array(':stats' => $stats, ':cid' => $cid)); ?> <script type="text/javascript"> alert("Have Successfully Updated"); window.location = "confirmedcustomers.php"; </script>