i have this code below its working fine but i need it to display result the other way round for example the code display result like this

On click(Nigeria) it shows drop menu of (3,6,4)
On click (Ghana) it shows drop menu of (5,2)

i want the code altered so it displays this way

On click(Nigeria) it shows drop menu of (5,2)
On click (Ghana) it shows drop menu of (3,6,4)


code below thanks



<?php
error_reporting(E_ALL);
ini_set('display_errors',0);
require_once('conn.php');
$country_result = $conn->query('select * from countries');
?>

<select name="country" id="countries-list">
<option value="">Select Country</option>
<?php
if ($country_result->num_rows > 0) {
// output data of each row
while($row = $country_result->fetch_assoc()) {
?>
<option value="<?php echo $row["id"]; ?>"><?php echo $row["country_name"]; ?></option>
<?php
}
}
?>
</select>
</br></br></br>
<select name="state" id="states-list">
<option value=''>Select State</option>

</select>
<?php

$country_id = mysql_real_escape_string($_POST['country_id']);
if($country_id!='')
{
$states_result = $conn->query('select * from states where country_id='.$country_id.'');
$options = "<option value=''>Select Name</option>";
while($row = $states_result->fetch_assoc()) {
$options .= "<option value='".$row['country_id']."'>".$row['state']."</option>";
}
echo $options;
}

?>


<script src="js/jquery-1.3.0.min.js"></script>
<script>
$('#countries-list').on('change', function(){
var country_id = this.value;
$.ajax({
type: "POST",
data:'country_id='+country_id,
success: function(result){
$("#states-list".html(result);
}
});
});
</script>

no response

Which URL are you making your Ajax call to?

chygoz3:
Which URL are you making your Ajax call to?

i only have aa menu code without d submenu so not calling yet

From my understanding of your code, when the page loads, the countries select input is populated with a list of countries. Assuming all the php code is in one file, the part where you are trying to get the States for a country will result in an error because $_POST['country-id'] will not have a value (loading the page the first time is done using the http GET method).
Now since you want to load the states in a selected country asynchronously via AJAX when a country is selected, you need to pass the fill the url parameter of ajax which tells Ajax which php file to call.
From the code you provided, it is unclear what the error you are trying to fix is.

chygoz3:
From my understanding of your code, when the page loads, the countries select input is populated with a list of countries. Assuming all the php code is in one file, the part where you are trying to get the States for a country will result in an error because $_POST['country-id'] will not have a value (loading the page the first time is done using the http GET method).
Now since you want to load the states in a selected country asynchronously via AJAX when a country is selected, you need to pass the fill the url parameter of ajax which tells Ajax which php file to call.
From the code you provided, it is unclear what the error you are trying to fix is.

ok i get what u saying, am think of trying something else, will update soon