--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -10,21 +10,22 @@
 */
 
 include_header("Procurement Methods");
-$query = "SELECT SUM(value) as value, procurementMethod
-FROM `contractnotice`
-WHERE childCN is null
-GROUP BY procurementMethod ";
+$query = 'SELECT SUM(value) as value, "procurementMethod"
+FROM contractnotice
+WHERE "childCN" is null
+GROUP BY "procurementMethod"';
 
-$result = mysql_query($query);
+    $query = $conn->prepare($query);
+    $query->execute();
+    databaseError($conn->errorInfo());
 
 echo "<table>";
-while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
+    foreach ($query->fetchAll() as $row) {
 setlocale(LC_MONETARY, 'en_US');
 $value = number_format(doubleval($row[0]),2);
     echo ("<tr><td><b>{$row[1]}</b></td><td>\$$value</td></tr>");
 }
 echo "</table>";
-mysql_free_result($result);
 include_footer();
 ?>