Generating a list (archive) of each year of the entries

[Red 09]

This is for a simple news archive.

 

I need help with a way to make a list like this:

 

2000

2001

2002

2003

(etc..)

 

Clicking on a year will display all entries posted that year.

 

The yearlist is to be extracted from news entries in a table, and each year is to occur only once in the list.

 

Could someone please help me out?

[Red 09]

Never mind, I figured it out:

 

SELECT DISTINCT YEAR(date) FROM articles GROUP BY date;

 

PS! It seems that YEAR() is case-sensitive. year(date) != YEAR(date) for some reason