Hola senor y senora.

I have a question on building drop down lists. Currently, I am working on a search engine. And I need drop down lists to go about doing this.

I have 2 drop down lists & 1 submit button.
I don't know how to explain in detail, do hope this point forms help you understand my situation better. :)

1. User selects table name from 1st drop down list.
2. DB retrieves field names from the selected table in 1st drop down list & displays in 2nd drop down list.
3. User selects the field name.
bla bla
bla bla bla bla..

Actually, I just want to know how can I tweak the codes in such a way that the 2nd drop down list will display the correct field names upon selection of tables from 1st drop down list??

I welcome all ideas, opinions, tips. :D


* Love me for a reason; Let the reason be love *

__________________
* Love me for a reason; Let the reason be love *