mysql list menu

[jd57]

Hi
this is my first try in php, can someone help me?
how can I modify this code to list queries in alphabetical order and eliminate duplicate names.
Thanks

<?php
mysql_connect("localhost", "xxx_xx", "xxxx") or die(mysql_error());
mysql_select_db("xxxx_xx") or die(mysql_error());
$query="SELECT Bloom_Name FROM ihs";
$result = mysql_query($query);

echo '<select name="ihs">';
while($nt=mysql_fetch_array($result)){ //Array or records stored in $nt
echo '<option value="' . $nt['id'] . '">' . $nt['Bloom_Name'] . '</option>';
/ Option values are added by looping through the array /
}
echo '</select>'; // Closing of list box

?>

[devinemke]

change your query to:

$query = 'SELECT DISTINCT Bloom_Name FROM ihs ORDER BY Bloom_Name';

[jd57]

🙂 Great!!!
One more thing, what code should I add to do the following.

<select name="select5"onChange= "Bloom_Name'.value=this.options[this.selectedIndex].text"
size="1">

<?php
mysql_connect("localhost", "xxx_xx", "xxxx") or die(mysql_error());
mysql_select_db("xxxx_xx") or die(mysql_error());
$query="SELECT Bloom_Name FROM ihs";
$result = mysql_query($query);

echo '<select name="ihs">';
while($nt=mysql_fetch_array($result)){ //Array or records stored in $nt
echo '<option value="' . $nt['id'] . '">' . $nt['Bloom_Name'] . '</option>';
/ Option values are added by looping through the array /
}
echo '</select>'; // Closing of list box
?>