--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -15,16 +15,17 @@
 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();

 ?>