--- 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,8 +29,8 @@ $query = 'SELECT "CNID", "description", "value", "agencyName", "category", "contractStart", "supplierName" FROM contractnotice - WHERE "agencyName" = :agency - ORDER BY "value" DESC'; + WHERE "agencyName" like :agency + ORDER BY "value" DESC limit 100'; $query = $conn->prepare($query); $query->bindParam(":agency", $agency); $query->execute();