æ°æ®åºè®¾è®¡ï¼
database: db;
table: sort1,sort2;
sort1-data: id name vablue
1 aa
2 bb
sort2-data: id name parent_id
1 aa-a 1
2 aa-x 1
3 bb-m 2
4 bb-j 2
å¨dwä¸æ¾ç½®2个跳转èåï¼
å¨ç¬¬ä¸ä¸ªselectä¸æ·»å¦ä¸ä»£ç ï¼
<option>---请éæ©---</option>
<?php
$host = "localhost";
$db_name = "db";
$username = "root";
$password = "";
$conn=mysql_connect($host,$username,$password) or die("ä¸è½é¾æ¥å°æ°æ®åº!");
$db=mysql_select_db($db_name,$conn);
$sql="select * from sort1 order by id ASC";
$result = mysql_db_query($db_name,$sql);
while($row = mysql_fetch_array($result)) {
$sort1_id = $row["id"];
$sort1_name = $row["name"];
$sort1_value = $row["value"];
if(!$sort1_value){
$str = "<option value = '?data1=$sort1_id'";
if($row["id"] == $data1){
$str .= "selected";
}
}
else{
$str = "<option value = '$sort1_value'";
}
$str .= ">$sort1_name</option>";
echo $str;
}
?>
温馨提示:答案为网友推荐,仅供参考