[Resolved] Simple Question..i think

[nick2005]

Hi,

I just wanna know how I can display only unique entries, if its possible?

I.e I have loads of rows with the number '16' and loads of rows with number '17' but I just wanna display 2 records, '16' and '17.'

The number of rows in the database will vary so i cant use a simple limit command.

Any help most appreciated.

Thanks.

[LordShryku]

SELECT DISTINCT field FROM table

[nick2005]

Cheers, I knew it would be something really simple!