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