jquery implements provincial and municipal secondary linkage menus

pro_city.php Initial page:

Provincial and municipal secondary linkage &lt ;/script> $(document).ready(function(){ ").load("show.php?id="+$("#province").val()); Cascade linkage

Please select a province $conn = mysql_connect("localhost","root","root"); //Connect to the database mysql_query("set names utf8"); mysql_select_db("bbs"); $rs = mysql_query ("select id,cname,parentid from areas where parentid='0'"); while($row = mysql_fetch_array($rs)) { ?> "> } ?>

show.php

header("content-type:text/html;charset=utf-8" );

$province_id = $_GET['id']; if($province_id=='10000000' || $province_id=='11000000' || $province_id=='18000000' || $province_id==' 31000000') { ={$province_id}"; }

$conn = mysql_connect("localhost","root","root"); ; $rs = mysql_query($sql);

$show = " "; while($row = mysql_fetch_array($rs)) { $ show .= " ".$row['cname']." "; } $show .= " ";

if($province_id=='-1') //When "Please select a province" is selected, the city list displays "Please select a city" { $show=" "; } echo $show; //Return the string to display on the page ?>