amadarohan
یک شنبه 10 شهریور 1392, 19:18 عصر
با اجازه!!!
از کد lagon 666 استفاده کردم....
فکر کنم منظور دوستمون همین باشه!
<html>
<head>
<script>
function SetStates(States) {
var stateBox = document.getElementById("state");
stateBox.options.length = 0;
if(States != "") {
var arrStates = States.split(",");
for(i = 0; i < arrStates.length; i++) {
if(arrStates[i] != "") {
stateBox.options[stateBox.options.length] = new Option(arrStates[i], arrStates[i]);
}
}
}
}
</script>
</head>
<body>
<pre>Country:
<select onChange="SetStates(this.value)" id="country">
<option value=""></option>
<option value="New South Wales,Queensland,Victoria,South Australia,Tasmania,Western Australia,Northern Territory">Australia</option>
<option value="California,New York,Ohio,Colorado,Florida,Texas,Arizona,Washingto n">USA</option>
<?php
$query="SELECT * FROM state";
$result=$database->query($query);
while($row=mysql_fetch_array($result)){
$query2="SELECT * FROM city WHERE state_id={$row['id']}";
$result2=$database->query($query2);
while($row2=mysql_fetch_array($result2)){
$ocity.=$row2['name'].",";
}
$oState="<option value=\"".$ocity."\">".$row['name']."</option>";
echo $oState;
}
?>
</select>State: <select id="state"></select>
</pre>
</body>
</html>