--- a/graphs/displayAgencySuppliersGraph.php +++ b/graphs/displayAgencySuppliersGraph.php @@ -2,7 +2,6 @@ include_once ("../lib/common.inc.php"); $agency = "AusAid"; $topX = 15; -$startYear = 2007; $query = "SELECT SUM(value) as val, supplierName FROM `contractnotice` WHERE (YEAR(contractStart) >= $startYear) AND childCN = 0 AND agencyName = '$agency' GROUP BY lower(supplierName) ORDER BY val DESC limit $topX"; $result = mysql_query($query);