I'm trying to create an archive page of links to articles added to a
database, and I would like to group these by months and years. So, for
example my first page would look something like;

April 2005
March 2005
February 2005
January 2005
Decemeber 2004

etc etc

Now, the code for displaying the pages thereafter is no problem (as I
can obviously use the month and year as a variable to search the DB for
the articles. What I am having a problem with however is how can I
query the database to simply find out months and years that have entries
, ideally omitting any months that don't.

Many Thanks in advance

LB