[contractdashboard.git] / displayProcurementMethod.php
--- 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();