search fixes
[contractdashboard.git] / search_autosuggest.php
blob:a/search_autosuggest.php -> blob:b/search_autosuggest.php
--- a/search_autosuggest.php
+++ b/search_autosuggest.php
@@ -7,7 +7,7 @@
 $aResults = array();
 $count = 0;
 if ($len) {
-    $query = 'SELECT MAX("supplierName"), MAX("supplierABN"), count(*) as count
+    $query = 'SELECT mode("supplierName"), MAX("supplierABN"), count(*) as count
 FROM contractnotice
 WHERE "supplierName" ILIKE :supplierName
 GROUP BY "supplierName"
@@ -47,7 +47,7 @@
         );
     }
         $query = "SELECT \"CNID\", description, value FROM contractnotice
-WHERE to_tsvector('english', description) @@ plaintoto_tsquery('english', :input)";
+WHERE to_tsvector('english', description) @@ plainto_tsquery('english', :input)";
     $query = $conn->prepare($query);
     $agencyName = $input . '%';
     $query->bindParam(":input", $input);
@@ -84,3 +84,4 @@
     echo "</results>";
 }
 ?>
+