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