--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -1,32 +1,33 @@
-<?php
-
-include_once("./lib/common.inc.php");
-/*
-
-biggest suppliers in each method
-biggest agencies in each method (weighted for size? percentage of total expenditure)
-
-largest Average value by procurement type?
-*/
-
-include_header("Procurement Methods");
-$query = "SELECT SUM(value) as value, procurementMethod
-FROM `contractnotice`
-WHERE childCN is null
-GROUP BY procurementMethod ";
-
-$result = mysql_query($query);
-
-echo "<table>";
-while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
-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();
-?>
-
-
+<?php
 
+include_once("./lib/common.inc.php");
+/*
+
+biggest suppliers in each method
+biggest agencies in each method (weighted for size? percentage of total expenditure)
+
+largest Average value by procurement type?
+*/
+
+include_header("Procurement Methods");
+$query = 'SELECT SUM(value) as value, "procurementMethod"
+FROM contractnotice
+WHERE "childCN" is null
+GROUP BY "procurementMethod"';
+
+    $query = $conn->prepare($query);
+    $query->execute();
+    databaseError($conn->errorInfo());
+
+echo "<table>";
+    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>";
+include_footer();
+?>
+
+
+