[nurqeen]

hi..i really need help..please...

my problem is, i want to retrieve records from Mysql database using drop down menu then i would like the choices that i made from the drop down menu to be display on the other drop down menu(second drop down menu) or the textfields..the second drop down menu also records from database..it will display records that match from the choices from the first drop down menu..

eg: First Drop Down Menu records from table 'country' from Mysql db
country = England, Jerman, USA

2nd Drop Down Menu records from table 'city' from Mysql db
city = London, Berlin, New York

so, when i choose England it will display London in 2nd Drop Down Menu

pleaseee...anyone help me..

[blaw]

Hi there,

Seems like you can use a combination of JavaScript and PHP.

Bug a onChange event to pass the value of selectedIndex to the script like script.php?country=EN , then based on what is passed as a country parameter, you can query the database for the city, assuming that you have the proper database set up for this. Then, create the second combobox based on whatever cities you have gotten from the query.

HTH.