Php/ajax - Country/state Chained Select Options

[quasiman]

Hello all,

Using php/mysql/ajax, I can't see how to autoselect the state when a country is preselected. See my code below...any help would be appreciated!
ajax:

<script src="/js/jquery-1.7.2.min.js" type="text/javascript"></script>
<script type="text/javascript">
	$(document).ready(function()
	{
		$(".country").change(function()
		{
			var dataString = 'id='+ $(this).val();
			$.ajax
			({
				type: "POST",
				url: "state.php",
				data: dataString,
				cache: false,
				success: function(html)
				{
					$(".state").html(html);
				}
			});
		});
	});
</script>

fields:

<tr>
        <td><strong>Country</strong></td>
        <td><select name="country" class="country">
        <option selected="selected">--Select Country--</option>
        <?php
                $query = "SELECT `id`, `iso`, `country` FROM regions ORDER BY `country`";
                $result = $mysqli->query($query) or die($mysqli->error . __LINE__);
                if ($result->num_rows > 0) {
                        while ($row = $result->fetch_assoc()) {
                                echo "<option value='" . $row['id'] . "' " . ($customer['country'] == $row['iso'] ? 'selected=\"selected\"' : '') . " >" . $row['country'] . "</option> \n";
                        }
                }
        ?>
        </select></td>
</tr>

state.php

PHP Code:

<?php
include ('includes/functions.php');
if($_POST['id'])
{
$id=$_POST['id'];
        $query = "SELECT id,region_id,name FROM subregions WHERE region_id = '$id'";
        $result = $mysqli->query($query) or die($mysqli->error . __LINE__);
        if ($result->num_rows > 0) {
                echo "<select name='state' >\n";
                echo "<option value='0'>====Choose State ====</option>\n";
                while ($row = $result->fetch_assoc()) {
                        echo "<option value='" . $row['name'] . "' >" . $row['name'] . "</option> \n";
                }
        } else {
                echo "<input name=\"state\" type=\"text\" name=\"other\" />";
        }
}
?>

[quasiman]

Nevermind, I got it...

$(document).ready(function()
{
	$(".country").change(function()
	{
		var dataString = 'id='+ $(this).val();                           
		$.ajax
		({
			type: "POST",
			url: "state.php",
			data: dataString,
			cache: false,
			success: function(html)
			{
				$(".state").html(html);
			} 
		});
	});
	$(".country").change(function() {  // bind a change event:
		$(this).val();
	}).change(); // and trigger a "change" event immediately
});