--- 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 = 0

-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();

 ?>