--- 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"