data from one combo to another
I have created few tables and combo boxes in my site. Please have a check on raihans.co.uk, log in with userdb, pwd: open. then hover on User Log In/Out and click on DB Test.
The Country, State or Province names are entered manually through codes.
I wishes to get the country entries in 1st Combo from my table (named, 'Test_Country') in mysql. Then as I click on any country, on the 2nd combo it will show the State from another table (named, 'Test_State'). Just as it is now, but from the database tables.
My table entries are like:
Test_Country - Country_Name, CountryID
Test_State - State_Name, StateID
Test_CountryState - CountryID, StateID
How I may do that, pls help me.
Thanking you in advance.