Using database data for SELECT OPTION statement

[jeffgman]

On one of my forms, I want to use a <SELECT> / <OPTION> setup, and pull the data from a mysql database. I have done that, and don't necessarily have a problem with that. My problem is the database will have duplicate information in it, how do I only select one of each unique value?

My database might have data like:

Ruger
Smith & Wesson
Colt
Remington
Colt
Smith & Wesson
Ruger
Ruger
Colt

But, I only want the output to be: (where each unique item is listed once)

Ruger
Smith & Wesson
Colt
Remington

How would I do that?

Thanks,
Jeff

[devinemke]

use SELECT DISTINCT in your query