--- a/displayProcurementMethod.php +++ b/displayProcurementMethod.php @@ -12,19 +12,20 @@ include_header("Procurement Methods"); $query = "SELECT SUM(value) as value, procurementMethod FROM `contractnotice` -WHERE childCN = 0 +WHERE childCN is null GROUP BY procurementMethod "; -$result = mysql_query($query); + $query = $conn->prepare($query); + $query->execute(); + databaseError($conn->errorInfo()); echo "
{$row[1]} | \$$value |