[contractdashboard.git] / displayProcurementMethod.php
--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -10,8 +10,9 @@
 */

 

 include_header("Procurement Methods");

-$query = "SELECT value, procurementMethod

+$query = "SELECT SUM(value) as value, procurementMethod

 FROM `contractnotice`

+WHERE childCN = 0

 GROUP BY procurementMethod ";

 

 $result = mysql_query($query);