Pulling unique items from MySQL.

[OntarioEastern]

Hey All,

I have a database that has about 400 items in it, but only a very limited number of "make" and "model" for the items. I want to generate the drop down form field to show the Make, and one for Model, but not have all 400 records populate the form.

Normally I would have a query like this:

SELECT make FROM cars Order BY make DESC

but that will give me every record. If Dodge, GMC, Ford and Chrysler are the only information in there, I want them just to show up once.. not for all 400 records.

[steadyguy]

Use the DISTINCT() SQL function:

SELECT DISTINCT(make)
FROM cars
ORDER BY make DESC;