Auto Fill Listbox After 3 characters entered??

[suess0r]

OK, here's what i'm looking for...

I want to be able to search through my DB for club_name = to the textbox being inputed. I can search and retrieve the data i'm looking for fine in the textbox, after they hit submit... but i'm trying to have a listbox appear under the textbox that autofills these results AS THEY ARE TYPING after the 3rd character. I'm not sure how to parse the field name by individual characters, nor how it refreshes after each letter and refreshes the results to match. Would I be wanting to look into javascript for this or what would you suggest?

just like www.kayak.com does on their search.

Thanks!  ;D

[papaface]

This would not be something PHP could do, as PHP is server-side not client-side. You would probably have to look into something like javascript for this.

[fert]

you could use AJAX

[suess0r]

ya that's what i figured, i'll look around.. thanks for the input

[artacus]

We have an Ajax forum so a mod might move this, but this is what you do.
You need an onkeypress handler on your input field. Check that the text length is > 2 and then fire off an ajax request that populates a list in an empty div right below your text field.

Each list item will have an onclick event handler that inserts its value into the text field then clears the div.

[willfitch]

You need to take a look at my article in this month's php|Architect magazine.  It could really help you out.

http://www.phparch.com/issue.php?mid=93

[mainewoods]

the w3schools ajax tutorial covers exactly how to implement the 'google suggestion' like feature you want:

http://www.w3schools.com/ajax/default.asp