more postgres migration
[contractdashboard.git] / displayAgency.php
blob:a/displayAgency.php -> blob:b/displayAgency.php
--- 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);