Hello from Paris !
I had to add "DISTINCT' in the SQL query to avoid duplicate suggests !
I hope this helps someone.

Hello Fabrice.

Can you explain your issue a little bit more detailed ?

Regards : Vulcho.

OK. I will try it :

I wanted to implement a field with Ajax AutoComplete to avoid multiple syntaxes of the same keyword.
The suggested list is from the same table.
So, necessarily, there are several records with the same keyword, and the suggested list returned by Ajax AutoComplete contains all the duplicates keywords.
So, I had to add "DISTINCT" in the SQL statement :

$sql = 'SELECT DISTINCT '.$fields.' FROM `'.$table.'`';

I hope this is more clear now.

Best regards.

Hello,

This is how the Ajax Autocomplete is supposed to work.