add amendments metric
[contractdashboard.git] / displayContract.php
blob:a/displayContract.php -> blob:b/displayContract.php
<?php <?php
include_once("./lib/common.inc.php"); include_once("./lib/common.inc.php");
include_header("Contract"); include_header("Contract");
$query = sprintf("SELECT * $query = sprintf("SELECT *
FROM `contractnotice` FROM `contractnotice`
WHERE CNID = '%d'", mysql_real_escape_string($_REQUEST['CNID'])); WHERE CNID = '%d'", mysql_real_escape_string($_REQUEST['CNID']));
$result = mysql_query($query); $result = mysql_query($query);
echo "<pre>"; echo "<pre>";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) { while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
setlocale(LC_MONETARY, 'en_US'); setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row['value']),2); $value = number_format(doubleval($row['value']),2);
echo(print_r(array_filter($row),true)); echo(print_r(array_filter($row),true));
} }
echo "</pre>"; echo "</pre>";
echo '<a href="https://www.tenders.gov.au/?event=public.advancedsearch.keyword&keyword=CN'.$_REQUEST['CNID'].'"> View original record @ tenders.gov.au</a>'; echo '<a href="https://www.tenders.gov.au/?event=public.advancedsearch.keyword&keyword=CN'.$_REQUEST['CNID'].'"> View original record @ tenders.gov.au</a>';
mysql_free_result($result); mysql_free_result($result);
include_footer(); include_footer();
?> ?>