两级联动mysql怎样查询_我的二级联动下拉框（方便以后查询）

var subcat2 = new Array();

$i=0;

$sql="select * from cat_small ";//查询所有小类

$result=mysql_query($sql);

while($rs=mysql_fetch_array($result))

{

echo "subcat2[".$i++."] = new Array('".$rs["id"]."','".$rs["cat_bigId"]."','".$rs["cat_name"]."');\n";

}

?>

function changeselect1(locationid)

{

document.leave_word.s2.length = 0;

document.leave_word.s2.options[0] = new Option('请选择','');

//alert(subcat2[1].toString());

//alert(locationid.length.toString());

for (i=0; i

{

if (subcat2[i][1] == locationid)

{

document.leave_word.s2.options[document.leave_word.s2.length] = new Option(subcat2[i][2], subcat2[i][0]);}

}

}

if(isset($_SESSION['name'])){

?>

用户=htmlspecialchars($_SESSION['name'])?>	注销
上传文件：	请选择 $sql = "select * from cat_big order by id "; $result = mysql_query($sql); $row = mysql_num_rows($result); while($rs = mysql_fetch_array($result)) { echo ""; echo $rs['cat_name']; echo ""; } ?> 请选择
描述：