--- a/displayAmendments.php
+++ b/displayAmendments.php
@@ -1,32 +1,32 @@
- 0 order by diff DESC";
-$result = mysql_query($query);
- echo "
-
- Contract |
- Original Value |
- Amended Value |
- 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 |
";
-}
-} else {
-echo mysql_error();
-}
-echo "
";
-mysql_free_result($result);
-include_footer();
-?>
+ 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 "
";
+include_footer();
+?>
+