--- a/lib/common.inc.php +++ b/lib/common.inc.php @@ -45,9 +45,10 @@ if ($supplierParts[0] > 0) $supplierQ = "supplierABN = '" . $supplierParts[0] . "' AND "; else $supplierQ = "supplierName LIKE '%" . $supplierParts[1] . "%' AND "; } +$startYear = 2007; $year = mysql_real_escape_string(stripslashes($_REQUEST['year'])); if ($year != "") $yearQ = "YEAR(publishDate) = " . $year . " AND "; - +$standardQ = "childCN = 0 AND YEAR(contractStart) >= 2007 AND YEAR(contractStart) <= 2010"; $start =0.0; function include_header($title) { @@ -59,9 +60,8 @@ Contract Dashboard - <?=$title?> - + - + + + + +