[RESOLVED] Only selecting one unique object on SELECT

[jme]

Hi all,

I'm in the middle of working with an auto complete script for a tag field. At the moment when doing a 'select tags from table' (to populate the array which feeds into the auto complete script) I might get results like this:

tag1
tag2
tag1
tag3
tag1
tag1
tag3

Therefore, when someone types tag1 they get more than one version of it. Is there a way, either php or sql that I can limit the number of times a certain item is added to the array or taken from the database so the select would look more like

tag1
tag2
tag3
tag4

Basically, just one unique instance of each tag in the database?

Many thanks in advance.

Jamie

[laserlight]

Declare the column as UNIQUE, or if you cannot do that, then use SELECT DISTINCT.

[jme]

Perfect. SELECT DISTINCT - Just what I was looking for.

Thanks for your help Laserlight 🙂