--- 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);