<select> help

[UnknownPlayer]

I have this form:

<form>
<label>Select Country:</label>
<select name="country" id="country">
	<?php
		$query = "SELECT * FROM countries";
		$result = mysql_query($query, $connection);
		while ($country = mysql_fetch_array($result)) {
			$county_id = $country['id'];
			$county_name = $country['name'];
			echo '<option value="{$county_id}">'.$county_name.'</option>';
		}
	?>
</select>
</form>

 

now i wonna, when someone choose some country, to read from "cities" table all cities which are in choosen country, and to make another <select> for choosing cities.. but without refreshing page.. i mean with js.

Can someone help me, please?

[inversesoft123]

you can do it with jQuery API.

[UnknownPlayer]

Can you give me example?

[inversesoft123]

http://api.jquery.com/submit-selector/