[RESOLVED] Selecting and Listing Duplicate Entries Once?

[middleman666]

hey people,

im a tad stuck with a mySQL query.
i have a database which has a field called catgory.
i would like to list these categories, but im gettin the problem where its simply listing all entries which means its listing the same category name a number of times.

does any one know the query code to stop this happening?

at the mo i have:
SELECT * FROM Photos ORDER BY category DESC

thank you,

[Roger_Ramjet]

You do it with the GROUP BY clause , and don't select * if all you want is the category list.

[middleman666]

cheers! knew it would be something simple like that.

SELECT Category FROM MaplelodgePhotos GROUP BY Category DESC