show unique values of a field

[Ember]

I'm working on a link management system and i am trying to find a way that I can populate a list of links based off a field. Here is how it works

When a user submits a link it has 5 fields.
database
|
--links
|
--id
--date
--url
--text
--approved

I display the links that have been submitted based off the date field. My date format is mdY (01012006). When the page is loaded it figures out the date and then displays it. I currently have a text link that I have to add each day that passes the url index.php?choosendate=04222006 (for example)

Is there a way to search the date field of the database and only pull out the different dates once and add them into a link?

for example if there is 5 links with 04212006 and 4 links with 04222006 it only pulls the date strings once instead of 5 and 4 times.

here is the work in progress I have
http://www.dirtyneedle.net/distractions

Thanks

[tomhath]

SELECT DISTINCT myColumn FROM myTable

[Ember]

Thanks, worked perfect