php - 从多个字段下拉菜单

这是我之前提出的问题的补充。在我的雕刻机下拉框中，我希望该框从三个字段Engraver1Surname，Engraver2Surname和Engraver3Surname收集姓氏。我还希望每个名称仅出现一次并按字母顺序排列。我的代码不起作用，这意味着我又一次出错了。这些东西确实具有挑战性，我很喜欢它，但我不想成为连环害虫，这就是我尝试过的方法。

$sql = "SELECT DISTINCT Engraver1Surname, Engraver2Surname, Engraver3Surname FROM engravers Where Engraver1Surname, Engraver2Surname, Engraver3Surname <> '' AND  Engraver1Surname, Engraver2Surname, Engraver3Surname IS NOT NULL ORDER by Engraver1Surname, Engraver2Surname, Engraver3Surname";
    $result = mysql_query($sql);

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

最佳答案

$name=array('Engraver1Surname','Engraver2Surname','Engraver3Surname');

$option=array();

while ($row = mysql_fetch_array($result)) {

      for($x=0;$x<3;$x++){
      $option.=$row[$name[$x]];
      }

}

asort($option);

for($y=0;$y<sizeof($option);$y++){
echo "<option value='" . $option[$y]. "'>" .$option[$y] . "</option>";
}

echo "</select>";

希望它能解决您的问题