0 order by diff DESC';
$query = $conn->prepare($query);
$query->execute();
databaseError($conn->errorInfo());
echo "
Amendments - Published Year $year
Contract |
Original Value |
Amended Value |
Difference |
";
foreach ($query->fetchAll() as $row) {
setlocale(LC_MONETARY, 'en_US');
$value = number_format(doubleval($row['value']), 2);
$pvalue = number_format(doubleval($row['pvalue']), 2);
$diff = number_format(doubleval($row['diff']), 2);
echo ("");
echo "{$row['description']} | ";
echo "\$$pvalue | \$$value | \$$diff |
";
}
echo "
";
include_footer();
?>