--- a/displayAgency.php +++ b/displayAgency.php @@ -29,7 +29,7 @@ $query = 'SELECT "CNID", "description", "value", "agencyName", "category", "contractStart", "supplierName" FROM contractnotice - WHERE "agencyName" = :agency + WHERE "agencyName" like :agency ORDER BY "value" DESC limit 100'; $query = $conn->prepare($query); $query->bindParam(":agency", $agency);