Hi, I have two select list, one to choose country and the other to choose city. The two select list are publuated from database.
I need the second select list to change to the cities of the country selected in the fist select list. Then happen after I click the submit button, but I want it to happen when the country selection change. How can I do it?
Here is the php code:
<?php
$country = strip_tags(trim($_POST['country']));
$cityname = strip_tags(trim($_POST['cityname']));
$areaname = strip_tags(trim($_POST['areaname']));
include("Misc.inc");
$connection = mysql_connect($host,$user,$password)
or die ("couldn.t connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn.t select database");
$query = " SELECT CountryName FROM COUNTRY ORDER BY CountryName";
$result = mysql_query($query)
or die ("Couldn\'t excute query");
/* create form containing selection list */
echo "<form action='addarea.php' method='POST'>
<select name='country' >\n";
while ($row = mysql_fetch_array($result))
{
extract($row);
if ($CountryName == $country)
{echo "<option selected value='$CountryName'>$CountryName \n";}
else
{echo "<option value='$CountryName'>$CountryName\n";}
}
echo "</select>\n";
/* GET COUNTRY ID*/
$query = " SELECT CountryID FROM COUNTRY WHERE CountryName='$country'";
$result = mysql_query($query)
or die ("Couldn't excute query");
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$CityCountryID= $row['CountryID'];
$query = " SELECT CityName FROM CITY WHERE CountryID=$CityCountryID ORDER BY CityName";
//echo $query;
$result = mysql_query($query)
or die ("Couldn\'t excute query");
/* create city selection list */
echo "<select name='cityname'>\n";
while ($row = mysql_fetch_array($result))
{
extract($row);
if ($CityName == $cityname)
{echo "<option selected value='$CityName'>$CityName \n";}
else
{echo "<option value='$CityName'>$CityName \n";}
}
echo "</select>\n";
/*GET city ID */
$query = " SELECT CityID FROM City WHERE CityName='$cityname'";
//echo $query;
$result = mysql_query($query)
or die ("Couldn't excute query");
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$AreaCityID= $row['CityID'];
//echo $AreaCityID;
echo "<input type='text' name='areaname'>";
echo "<input type='submit' value ='submit'></form>";
/* insert data into Areas Table */
if ($areaname !="" AND $AreaCityID != "" AND $CityCountryID !="")
{
$query = "INSERT INTO Areas(CityID,AreaName) VALUES ($AreaCityID, '$areaname')";
//Echo $query;
$result = mysql_query($query)
or die ("Couldn't excute query");
//Echo $result;
}
/* Display all areas in City */
echo "County: $country<br>";
echo "City: $cityname<br>";
$query = "SELECT AreaName FROM AREAS WHERE CityID=$AreaCityID ORDER BY AreaName";
//echo $query;
$result = mysql_query($query)
or die ("Couldn't execute query.");
while ( $row = mysql_fetch_array($result))
{
extract($row);
echo "$AreaName<br>";
}
?>
