--- a/displayAgency.php +++ b/displayAgency.php @@ -30,7 +30,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();