--- a/displayProcurementMethod.php +++ b/displayProcurementMethod.php @@ -10,10 +10,10 @@ */ 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"'; $query = $conn->prepare($query); $query->execute();