且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

mysql在PHP中选择不同的查询

更新时间:2023-01-24 15:07:43

你应该这样做:

$sql = "SELECT DISTINCT Branch FROM student_main";
$result = mysql_query($sql);

echo "<select name='Branch'>";
while ($row = mysql_fetch_array($result)) {
    echo "<option value='".$row[0]."'>".$row[0]."</option>";
}
echo "</select>";

echo "<input type='submit' Value='submit' />";
echo "</form>";