php+ajax無重新整理實現省、地、市三級聯動二

<?
$conn=mysql_connect("localhost","root","2328725");
mysql_select_db("novel");
mysql_query("set names 'utf8'");
if($provincecode!=""&&$provincecode!=650000&&$provincecode!=710000&&$provincecode!=810000&&$provincecode!=820000&&$provincecode!=110000&&$provincecode!=120000&&$provincecode!=310000&&$provincecode!=500000){
  $sql="select * from city where provincecode=$provincecode";
  $result=mysql_query($sql);
  echo "<select onchange='queryArea(this.options[this.selectedIndex].value)'>\n";
  echo "<option value='-1' selected>請選擇城市</option>\n";
  while($row=mysql_fetch_row($result)){
   echo "<option value='$row[1]'>$row[2]</option>\n";
  }
  echo "</select>\n";
}

if($citycode!=""){
  $sql="select * from area where citycode=$citycode";
  $result=mysql_query($sql);
  echo "<select>\n";
  echo "<option value='-1' selected>請選擇縣</option>\n";
  while($row=mysql_fetch_row($result)){
   echo "<option value='$row[1]'>$row[2]</option>\n";
  }
  echo "</select>\n";
}
?>