php mysql jquery AJAX智能自动完成解决方案

Question

I have a mysql table with a column containing a list of names.

Can anybody tell me the best plugin or solution for making an autosuggestion list in my form input field using jquery?

I need something which supports

$query = "SELECT * FROM my_table WHERE name LIKE '%$_POST[]"name"%' ";

limiting to 10

I need a package including js libraries and php files.

I need the smartest and powerful autocomplete solution which check for matches in my every key stroke, available today.

Thanks in advance.

blasteralfred

Answer 1

jQuery UI auto complete, you will need the do the server side interaction code though.

http://jqueryui.com/demos/autocomplete/