Removing Duplicates.

Anon

What I am doing is calling "resorts" from a database and putting them in a dropdown menu. This dropdown menu ultimately ends up being used in my search engine.

Anyways, my problem is when I call the field "resort" from my dbase I get tons of the same... I just want it to remove all duplicates...

So for example. If I have 10 resorts called "Abba" in my dbase and another 10 resorts called "Abba2" in my dbase, I only want to dropdown menu to give me the option to choose from Abba/Abba2, not 20 (10 of each).

Here is my current code:

<?php

require("dbset.inc");
$Query = "SELECT id, resort FROM vacation ORDER BY resort;";
$queryexe = mysql_query($Query, $db);
while($row = mysql_fetch_row($queryexe))
{
$id = $row[0];
$name = $row[1];
print ("<option VALUE='$name'>$name");
}
?>

Anon

But which resort id would be used? If there are 10 'Abba2's in the database, each with a different id, which id would you want to use when you only display a single 'Abba2'???

If they all have the same id (i.e. the id field isn't a primary key, just an ordinary field), you could use the SELECT DISTINCT syntax, but I suspect you have differing ids. In which case, you could try experimenting with SELECT ........ GROUP BY resort

Anon

You are right when you suspected that they all have differing id's. As long as I can get it to choose a resort name for each resort in the database, then that is all I need.

Basically I just want my dropdown to display a name for each resort in the database, while removing all duplicates.

I then submit my form with the dropdown and my database returns all entries with resort = '$resort'.

I am going to try the GROUP BY thing right now.

Thanks,

Jeff

Anon

GROUP BY did the trick. Thanks a million!

Anon

No problem at all. Of course, if you don't need the id anyway, then a quicker solution would be to just use:

SELECT DISTINCT resort FROM vacation ORDER BY resort