populating dropdown from mysql problem

[Aviezero]

MySQL

key | value1

1 | a
2 | b
3 | a
7 | c

i need to echo "a, b, c"
not "a, b, a, c"

is there a function or common method for doing this?

[sid]

SELECT DISTINCT value1
FROM table
ORDER BY value1;

[Aviezero]

thank you so very much

[bradgrafelman]

Don't forget to mark this thread resolved.