我创建了一个html表单 . 在那里我有2个下拉列表 . 下拉列表1从sql数据库表中检索值并在那里显示 . 现在我想显示另一个下拉列表,其中包含来自下拉列表1的输入 .
这是我的代码:
Select a Building
session_start();
include 'db_connection.php';
$conn = OpenCon();
$sql = "SELECT bname FROM building_details";
$result = mysqli_query($conn, $sql);
echo "";
while ($row = mysqli_fetch_array($result)){
echo "".$row['bname'] ."";
}
echo "";
echo "Select a rtype";
$sql2 = "SELECT rtype FROM room_details WHERE bname='bname'";
$result2 = mysqli_query($conn,$sql2);
echo "";
while ($row2 = mysqli_fetch_array($result2)){
echo "".$row2['rtype'] ."";
}
echo "";
这里一旦bname值从building_details被选中然后根据该输入我需要显示另一个下拉列表,它是来自room_details表的rtype列 . 有人可以帮我弄这个吗???