--- a/displayAmendments.php
+++ b/displayAmendments.php
@@ -1,20 +1,32 @@
0) a where CNID = ccn order by diff DESC";
-$result = mysql_query($query);
-echo "
";
-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 |
";
+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 |
+ 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 "
";
-mysql_free_result($result);
include_footer();
?>