Log in

View Full Version : PHP / SQL - Dont show dublicate...



nikomou
07-25-2006, 10:06 PM
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
07-25-2006, 10:09 PM
select distinct name from manufactures;
i think :p

blm126
07-25-2006, 10:28 PM
we need a little more information

Twey
07-25-2006, 10:35 PM
SELECT manufacturer FROM tablename GROUP BY manufacturer;