<?php include("config.php"); $pkgid = $_GET['pkgid']; $stat = 'Yes'; $sql1 = $js->prepare('UPDATE package SET tripstatus = :stat WHERE pkgid = :pkgid'); $status1 = $sql1->execute(array(':stat' => $stat, ':pkgid' => $pkgid)); ?> <script type="text/javascript"> alert('Have suceesfully set the package to the Trips website'); window.location = 'view_packages.php'; </script>