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