Help making a form that finds existing posts

[badeand]

Hi,

 

I'm trying to make a form that will submit a customers order into my database. The form it self is no problem and posting it to the database that part I can do, but I want this form to find existing posts in my database as the user inputs information.

 

As an example if I add an ordrer for a customer ordering item numberr "1234" the form will search for item numberr "1234" and print it back to the form before the user submit the form, like "auto finish" the form.  So in other words it will search the database "on the fly" for this item and fill it in.

 

Could someone point me in the right direction? Somewhere in the PHP manual or maybe a good tutorial on this topic.

[BlueSkyIS]

perhaps someone has a favorite (i do not), but this will put you on the track of tutorials:

 

http://www.google.com/search?client=safari&rls=en&q=php+autocomplete&ie=UTF-8&oe=UTF-8

[badeand]

Thanks alot BlueSkyls,

 

Do you now if this is possible:

 

If you write in item number "1234" the next field called "Item description" is autocompleted with the "Item description" for item number "1234" ?

[BlueSkyIS]

yes. i would use ajax (Javascript and PHP working together), which is also what i would use for the auto-complete.