--- 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 ""; } ?> +