--- a/displayContract.php +++ b/displayContract.php @@ -1,21 +1,87 @@ -"; -while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { -setlocale(LC_MONETARY, 'en_US'); -$value = number_format(doubleval($row['value']),2); -echo(print_r(array_filter($row),true)); -} -echo ""; -echo ' View original record @ tenders.gov.au'; - -mysql_free_result($result); -include_footer(); +prepare($query); +$query->bindParam(":CNID", $_REQUEST['CNID']); +$query->execute(); +$contractResult = $query->fetch(PDO::FETCH_ASSOC); +if (!$contractResult) { + header("Status: 404 Not Found"); + header("HTTP/1.0 404 Not Found"); +include_header("Contract Not Found"); + echo "