removing a duplicate value

[planetphp]

Hi,

I am writing a search script to search for property in a database.

One of the fields is area. I don't want to design the site with pre-determined areas in the search forms, so I want a small piece of code to search the area field in a mysql table. I can do this no problem but if an area comes up more than once the search box is going to have the same area listed more than once which looks bad.

$query = "select area from local";
$result = mysql_query($query);
while($data = mysql_fecth_row($result)){

[planetphp]

oops... pressed submit by mistake

$query = "select area from local";
$result = mysql_query($query);
while($data = mysql_fetch_row($result)){

$area = $data[0];

echo "<select>$area</select>";

}

what can i do to process the results so I only get one return of multiple areas?

Please help!

[DigitalExpl0it]

try using DISTINCT in your query string

SELECT DISTINCT

[planetphp]

your a diamond!!!