a question...

[stew]

basically i need a function of bit of code that will search a database of say cities in europe, and i'd like to then display all the different cities, with no duplicates. basically if the database read:

london
glasgow
amsterdam
london

i would only want to display london, amsterdam and glasgow

hope this is clear

stew

[drawmack]

select distinct(city) from table

[Thora_Fan]

you could also say

SELECT city FROM table GROUP BY city