How do I, echo table row only once, if duplicate exists?

[listenmirndt]

Hi folks,

I have a table setup somthing like this :

FILE - DIRECTORY
1.jpg - directory1
2.jpg - directory1
3.jpg - directory1
4.jpg - directory2
5.jpg - directory2

When I echo the entire DIRECTORY row, looks like :

directory1
directory1
directory1
directory1
directory2
directory2

But I want it to look like :

directory1
directory2

Is this possible?

Thanks in advance.

[LordShryku]

Limit it in your SQL.

SELECT DISTINCT DIRECTORY
  FROM table

[listenmirndt]

awsome.
thats works perfect

thanks!

rofl. great sig btw.