TC-MZZ
TC-MZZ
TC-CTA
şeklindeki veriler comboboxda gözüküyor
şayet
$sql="SELECT DISTINCT tailname.tailname as ucakad, faultyreporter.id FROM faultyreporter INNER JOIN tailname ON tailname.id=faultyreporter.tailid";
şeklindeki bir ifadede ise yine aynı çıktıyı görüyorum. Bunun nasıl çözebilirim ki TC-MZZ ve TC-CTA sadece ekranda belirsin?
Kod: Tümünü seç
$sql="SELECT tailname.tailname as ucakad, faultyreporter.id FROM faultyreporter INNER JOIN tailname ON tailname.id=faultyreporter.tailid";
$result=mysql_query($sql);
$options="";
while ($row=mysql_fetch_array($result)) {
$id=$row["id"];
$name=$row["ucakad"];
$options.="<OPTION VALUE=\"$id\">".$name.'</option>';
}
?>
<SELECT NAME=tailname>
<OPTION VALUE=0>
<? echo $options?>
</SELECT>
</tr>