Data update
[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"