--- 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();