[RESOLVED] Returning 1 instance of a record depending how many there are.

[include_me]

Hi there, The subject might sound a bit weird but Im having trouble describing my problem,

basically I have a database with following fields prodId, prodMan, prodItem

For example say I have in the DB:

1, Man 1, ProdItem1
2, Man 1, ProdItem2
3, Man 1, ProdItem3
4, Man 2, ProdItem4
5, Man 2, ProdItem5
6, Man 3, ProdItem6
7, Man 3, ProdItem7

what I want to acheive is a piece of code that looks through the DB at the prodMan and then prints out each different prodMan record so I would get...

Man 1
Man 2
Man 3

without it duplicating the same prodMan

Can anyone help? :queasy:

Thanks,
Chris

[laserlight]

You can do a SELECT DISTINCT(prodMan)

[NogDog]

I don't think you need the parentheses:

SELECT DISTINCT prodMan FROM tableName ORDER BY prodMan

[include_me]

Thanks so much, it worked perfectly!

Chris