--- a/search_autosuggest.php +++ b/search_autosuggest.php @@ -49,7 +49,6 @@ $query = "SELECT \"CNID\", description, value FROM contractnotice WHERE to_tsvector('english', description) @@ plainto_tsquery('english', :input)"; $query = $conn->prepare($query); - $agencyName = $input . '%'; $query->bindParam(":input", $input); $query->execute(); databaseError($conn->errorInfo());