--- a/displayAgency.php +++ b/displayAgency.php @@ -3,11 +3,12 @@ include_once ("./lib/common.inc.php"); if ($_REQUEST['agency']) { - include_header("Agency"); $agency = htmlentities(strip_tags($_REQUEST['agency'])); - //MethodCountGraph($agency); - // CnCGraph($agency); - //MethodValueGraph($agency); + include_header($agency); +echo '

'.$agency.'

'; +// MethodCountGraph($agency); + // CnCGraph($agency); + // MethodValueGraph($agency); /* biggest contracts spending by year spending by industry/category @@ -28,7 +29,7 @@ $query = 'SELECT "CNID", "description", "value", "agencyName", "category", "contractStart", "supplierName" FROM contractnotice - WHERE "agencyName" = :agency + WHERE "agencyName" like :agency ORDER BY "value" DESC limit 100'; $query = $conn->prepare($query); $query->bindParam(":agency", $agency);