forms with mysql

[beanieboy]

Hi,

 

currently i have a form select list with a daft amount of select items. I have put these into a mysql db.

 

The db is called sfdb and has one field called stations.

 

On my php form i want to be able to type into a box and it automatically search the mysql db for wildcard matches each time i type a single character and display them on a drop down select list.

 

i.e.

 

typing Bra , would return...bradford;bracknell;branchton etc.

 

then typing Brad, would just return Bradford.

 

Can this be done??

 

Many Thanks

 

Imran

[Yesideez]

Yes - can be done but you'll be looking at AJAX/Javascript for this.