Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2010

    Unanswered: populating the drop down list based on the selected value of first list

    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

  2. #2
    Join Date
    Sep 2009
    San Sebastian, Spain

    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.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    Follow me on Twitter

  3. #3
    Join Date
    Sep 2010
    I am new to mysql and php .I am using xlinesof PHPrunner.
    Thanks for your time.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts