--- a/displayHeatmap.php +++ b/displayHeatmap.php @@ -26,7 +26,7 @@ $white = imagecolorallocate($handle, 0, 0, 0); imagecolortransparent($handle, $white); -$query = 'SELECT "supplierPostcode", sum("value") as value, max(lat) as lat, max(lon) as lon FROM contractnotice inner join postcodes on "supplierPostcode" = postcode::text where "childCN" = 0 AND "supplierCountry" = \'Australia\' GROUP BY "supplierPostcode"'; +$query = 'SELECT "supplierPostcode", sum("value") as value, max(lat) as lat, max(lon) as lon FROM contractnotice inner join postcodes on "supplierPostcode" = postcode::text where "childCN" is null AND "supplierCountry" = \'Australia\' GROUP BY "supplierPostcode"'; $query = $conn->prepare($query); $query->execute(); if (!$query) {