--- a/displayProcurementMethod.php
+++ b/displayProcurementMethod.php
@@ -12,7 +12,7 @@
 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);