sql query for unique items

[Anon]

Hi

Here's my present query:

SELECT recordID, item, thumbID
FROM $CFG->dbtbl
WHERE category like '$category' AND maingroup like '$maingroup'

Some items in the db are the same but in different places. They do however have he same recordID. How can I rewrite this to make sure that only disting recordID items get retrieved. I tried using DISTINCT but I did not get it to work. Not really sure how.

Thanks

Jadow