Select Option List Help - Multiple Values Are The Same

[twilitegxa]

I have this code for a select option list:

 

<?php
$get_map = "select * from monsters1";
$get_map_res = mysql_query($get_map, $conn) or die(mysql_error());
echo "<select name=\"maps\" onchange=\"showMap(this.value)\">
<option selected=\"selected\">None Selected</option>";
while ($list_maps = mysql_fetch_array($get_map_res)) {
$map_id = $list_maps['id'];
$map = $list_maps['map'];
echo "<option value=\"$map_id\">$map</option>";
}
echo "</select>";
?>

 

But I have several records with the same value. How can I make it to where each value only displays once in my list?

[mmarif4u]

You can use group by for that field.

 

$get_map = "select * from monsters1 group by map";

 

You can change map to the field, which you want to show once.

[twilitegxa]

Oh, thank you so much! I knew it was something simple, I just couldn't remember what it was. Thanks so much!