DROP DOWN BOX

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kandiekip
Forum Newbie
Posts: 1
Joined: Mon Oct 17, 2016 1:05 pm

DROP DOWN BOX

Post by kandiekip »

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.
Post Reply