I am using jquery to populate cities from selected country in a <select> element using the below code. This working perfect when opening it for a new company record. what if I want to edit existing record by detecting the $_GET["id"] of the company? I am setting the cboCountry value to $company_country which is a value from MySQL.. now how can I populate the modify below code to populate the cities for the selected country ($company_country) and also make the selected city = $company_city.

Hope my question is clear.. with thanks,,

here is the code:

2. <tr>
3.     <td valign="middle">Country</td>
4.     <td valign="middle">:</td>
5.     <td valign="middle">
6.         <select name="cboCountry" id="cboCountry" style="width: 100%" required>
7.             <option value="">[Country..]</option>
8.             <?php
9.                 $mysql_command = "CALL sp_populate_country()";
10.                 $mysql_query = $mysql_connection->prepare($mysql_command);
11. 
    
12.                 $mysql_query->execute();
13. 
    
14.                 while($mysql_row = $mysql_query->fetch())
15.                 {
16.             ?>
17.             <option value="<?php echo $mysql_row['country_code_alpha2']; ?>" <?php if ($mysql_row['country_code_alpha2'] == $company_country) { echo 'selected'; } ?>><?php echo $mysql_row['country_name']; ?></option>
18.             <?php } ?>
19.         </select>
20.     </td>
21. </tr>
22. <tr>
23.     <td valign="middle">State / City</td>
24.     <td valign="middle">:</td>
25.     <td valign="middle">
26.         <img id="imgLoading" src="<?php echo $_SESSION["domain_name"]; ?>images/loading_20X20.gif" alt="XoomPage" hidden>
27.         <select name="cboRegion" id="cboRegion" style="width: 100%">
28.             <option value="">[State / City..]</option>
29.         </select>
30.     </td>
31. </tr>

2.     $("#cboCountry").change(function() {
3.         // var country = $(this).find("option:selected").val();
4.         $("#cboRegion").hide();
5.         $("#imgLoading").show();
6.         // alert(country);
7.         $.ajax({
8.         url : "populate_region.php?id=" + $(this).val(),
9.         type: 'GET',
10.         dataType:'json',
11.         cache: false,
12.         success : function(data) {
13.             if (data.success) {
14.                 $("#cboRegion").html(data.options);
15.                 $("#imgLoading").hide();
16.                 $("#cboRegion").show();
17.             }
18.             else
19.             {
20.                 alert("Error! Unable to populate states / cities!");
21.             }
22.         }
23.     });
24. });