--- a/displayAgency.php +++ b/displayAgency.php @@ -5,9 +5,9 @@ include_header("Agency"); $agency = htmlentities(strip_tags($_REQUEST['agency'])); - MethodCountGraph($agency); - CnCGraph($agency); - MethodValueGraph($agency); + //MethodCountGraph($agency); + // CnCGraph($agency); + //MethodValueGraph($agency); /* biggest contracts spending by year spending by industry/category @@ -29,7 +29,7 @@ "contractStart", "supplierName" FROM contractnotice WHERE "agencyName" = :agency - ORDER BY "value" DESC'; + ORDER BY "value" DESC limit 100'; $query = $conn->prepare($query); $query->bindParam(":agency", $agency); $query->execute();