Change references to numeric child/parent IDs which can now be text
[contractdashboard.git] / displayAgency.php
blob:a/displayAgency.php -> blob:b/displayAgency.php
--- a/displayAgency.php
+++ b/displayAgency.php
@@ -66,7 +66,7 @@
 agenciesGraph();

   $query = 'SELECT SUM("value"), "agencyName"

 FROM contractnotice

-WHERE "childCN" = 0

+WHERE "childCN" is null 

 GROUP BY "agencyName" ';

 $query = $conn->prepare($query);

 	$query->execute();