Php mysql
I have created a database named "kenya" with tables
TABLES
1."counties",
2."subcounties",
3 "constituency".
4" mylist"
---------------------------------------
**in table 1,fields are
-ctycode(pk)
-county_name
---------------------------------------
**in table 2,fields are
- ctycode(fk)
-subctycode(pk)
-Subcounty_name
---------------------------------------
***in table 3,fields are
- ctycode(fk)
-subctycode(fk)
-Conscode (pk)
-constituency_name
***in table 4,fields are
-county-name
-subcounty-name
-constituency-name
I have an index.Php file which I have created a form to submit data to table 4. In the form I need to create a county drop down box/ list that will get populated by data from counties table.then it will make the other two drop down boxes for subcounty and constituency display filtered data from their respective tables that belong to only the chosen constituency and save in table 4
---------------------------------------
How will I code this? Please assist.
DROP DOWN BOX
Moderator: General Moderators