--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -1,31 +1,33 @@
-";
-while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
-setlocale(LC_MONETARY, 'en_US');
-$value = number_format(doubleval($row[0]),2);
- echo ("
{$row[1]} | \$$value |
");
-}
-echo "";
-mysql_free_result($result);
-include_footer();
-?>
-
-
+prepare($query);
+ $query->execute();
+ databaseError($conn->errorInfo());
+
+echo "";
+ foreach ($query->fetchAll() as $row) {
+setlocale(LC_MONETARY, 'en_US');
+$value = number_format(doubleval($row[0]),2);
+ echo ("{$row[1]} | \$$value |
");
+}
+echo "
";
+include_footer();
+?>
+
+
+