来自mysql的多个下拉列表

Question

I want to make multiple dropdowns from data out of my mysql database. I want 4 dropdowns to be exact. This is what I have at this moment:

<?php

mysql_connect('#', '#', '#');
mysql_select_db('test');

$sql = "SELECT wie, waar, metwie, voeruig FROM data";
$result = mysql_query($sql);

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

}
echo "</select>";
?>

Answer 1

For instance, this:

mysql_connect('#', '#', '#');
mysql_select_db('test');

$sql = "SELECT wie FROM data";
$result = mysql_query($sql);
echo "<select name='test1'>";
while ($row = mysql_fetch_array($result)){
    echo "<option value='" . $row['wie'] . "'>" . $row['wie'] . "</option>";
}
echo "</select>";

$sql = "SELECT waar FROM data";
$result = mysql_query($sql);
echo "<select name='test1'>";
while ($row = mysql_fetch_array($result)){
    echo "<option value='" . $row['waar'] . "'>" . $row['waar'] . "</option>";
 }
 echo "</select>";

$sql = "SELECT metwie FROM data";
$result = mysql_query($sql);
echo "<select name='test2'>";
while ($row = mysql_fetch_array($result)){
    echo "<option value='" . $row['metwie'] . "'>" . $row['metwie'] . "</option>";
 }
 echo "</select>";

$sql = "SELECT voeruig FROM data";
$result = mysql_query($sql);
echo "<select name='test3'>";
while ($row = mysql_fetch_array($result)){
    echo "<option value='" . $row['voeruig'] . "'>" . $row['voeruig'] . "</option>";
 }
 echo "</select>";
?>