PHP / SQL - Dont show dublicate...

[nikomou]

I want to list all the manufactures in my database, but dont want them showing up more than once...

Can anyone help me on this?

Cheers

[jr_yeo]

select distinct name from manufactures;
i think :p

[blm126]

we need a little more information

[Twey]

SELECT manufacturer FROM tablename GROUP BY manufacturer;