Select 'brand' column and remove/condense duplicates

[dachshund]

I'm building a shopping site with various section - men's, women's, accessories etc.

 

What I need to do is find what brands are available in each section.

 

In the datatbase the item has item id, title, brand, price, section etc.

 

So I need something like

 

SELECT brand FROM store WHERE id LIKE $id AND section LIKE $section

 

That will select all the brands, but then I need to condense those down and find any duplicates. Any help would be amazing.

 

Thanks

[Pikachu2000]

SELECT DISTINCT field FROM table WHERE . . .

[dachshund]

thanks