[SOLVED] Display only one row of each of the same text in output

[jaxdevil]

I am generating a drop down box dynamically based on the entries in the database. I want the drop down to only show one line for each unique entry. Like if there are 8 entries that say Jacksonville I want it to just show 1 entry for Jacksonville, etc. So the output will not show any duplicates. Anyone now how I can modify this to display each entry just once?

 

<SELECT NAME="location">
<OPTION VALUE="NONE">-----Select Product Location----
<?php
$sql = "SELECT * FROM locations";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query)) {
?>
<OPTION VALUE="<?=$row['locations']?>"><?=$row['locations']?>
<?php
}
?>
</SELECT>

[rhodesa]

$sql = "SELECT locations FROM locations GROUP BY locations";

[jonsjava]

<?php
$sql = "SELECT DISTINCT(`locations`) FROM locations";

[rhodesa]

Not sure if it's true or not, but I've been told GROUP BY is faster then DISTINCT

[jonsjava]

DISTINCT is the standard way.

[jonsjava]

must be tired:

<?php
$sql = "SELECT DISTINCT `locations` FROM locations";

[jaxdevil]

You are all da man!!