hi,I have a table with columns: country and states
How to narrow down (or limit) the items in a second drop down list based on the selected item from first selected item? For example if we have one list of countries in first drop down list and have list of states in the second list then once USA is selected from the country list then the second list should change to list only the states of USA.

I want to do this with select statement.

thank you

Hi,

what have you tried so far? Populating the dropdown is not controlled within MySQL but is done through your programming language, PHP, Visual Basic ... If you let us know what you have done so far and with which tools we can point you in the right direction.

I am new to mysql and php .I am using xlinesof PHPrunner.
Thanks for your time.