Prettier JQuery tables
[contractdashboard.git] / graphs / displayAgencySuppliersGraph.php
blob:a/graphs/displayAgencySuppliersGraph.php -> blob:b/graphs/displayAgencySuppliersGraph.php
--- 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);