i need an assistant with cascading drop down list based on a database. the cascading dropdown must be 4 below its a from and database , please note i am new on php and sql
Here is my inputs
<div class=”control-group”>
<label class=”control-label”><?php echo get_phrase(‘country’);?></label>
<div class=”controls”>
<select name=”province” class=”uniform” style=”width:100%;”>
<option value=””><?php echo get_phrase(‘select_country’);?></option>
</select>
</div>
</div>
<div class=”control-group”>
<label class=”control-label”><?php echo get_phrase(‘province’);?></label>
<div class=”controls”>
<select name=”province” class=”uniform” style=”width:100%;”>
<option value=””><?php echo get_phrase(‘select_province’);?></option>
</select>
</div>
</div>
<div class=”control-group”>
<label class=”control-label”><?php echo get_phrase(‘region’);?></label>
<div class=”controls”>
<select name=”region” class=”uniform” style=”width:100%;”>
<option value=””><?php echo get_phrase(‘select_region’);?></option>
</select>
</div>
</div>
<div class=”control-group”>
<label class=”control-label”><?php echo get_phrase(‘branch’);?></label>
<div class=”controls”>
<select name=”region” class=”uniform” style=”width:100%;”>
<option value=””><?php echo get_phrase(‘select_branch’);?></option>
</select>
</div>
</div>
DROP TABLE IF EXISTS `member
/*!40101 SET @saved_cs_client = @@character_set_client
/*!40101 SET character_set_client = utf8
CREATE TABLE `Member
`ID
`country
`province
`region
`branch
PRIMARY KEY (`ID
) ENGINE=InnoDB AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client
Here are countries = Provinces
south_africa = Gauteng, Western Cape, Kwazulu nal
botswana = botswana
lesotho = Lesotho
mozabique = Other
namibia = Other
swaziland = Other
zimbabwe = Other
other
and here are my provinces
Province = Branch
Gauteng = Soweto, Johannesburg
Western Cape = Cape Town
Kwazulu natal = Durban
Botswan = Gaborone