--- a/displayAmendments.php
+++ b/displayAmendments.php
@@ -1,10 +1,14 @@
0 order by diff DESC";
-$result = mysql_query($query);
- echo "
+include_header("Amendments");
+$query = 'select "CNID", description, value, pvalue, (value - pvalue) as diff from contractnotice,
+ (SELECT "CNID" as cn, "childCN" as ccn, value as pvalue FROM contractnotice where "childCN" is not null) a' .
+ ' where ' . $agencyQ . $yearQ . ' "CNID" = ccn AND (value - pvalue) <> 0 order by diff DESC';
+$query = $conn->prepare($query);
+$query->execute();
+databaseError($conn->errorInfo());
+echo "
Contract |
Original Value |
@@ -12,21 +16,17 @@
Difference |
";
-if ($result) {
-while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
- 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 |
";
+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 |
";
}
-} else {
-echo mysql_error();
-}
+
echo "
";
-mysql_free_result($result);
include_footer();
?>