retrieving the value of a combobox in PHP

See more:

PHP

Good Day all

i am facing a challenge with my code. what i am trying to do is have two comboboxes one called province and the other one city, when the user selects a province it should only display the cities in that province in the city combobox. how can i achive this using PHP ?

function getCity($provinceId)
    {
        $sql ="SELECT `cityid`,`cityname` FROM `tblcity` inner join `tblprovince` ON `tblcity`.`pid`='$provinceId'  order by `cityid` asc";
        $query = mysql_query($sql) or die ("Could not access DB: " . mysql_error());
			$row = mysql_fetch_assoc($query);		
			while($row)
			{
			$id = $row['cityid'];
			$name = $row['cityname'];
			echo 
			"
				<option value ='$id'>".$name."</option>
			";  
			$row = mysql_fetch_assoc($query);
		   }
     }

this is what my fuction looks like now i am unable to retrieve the values of the province combo box. any help will be appreciated.

Thanks in advance