Archiving my Blog

[SDP2006]

Need a little help here

Here is my problem. For every blog entry, I insert the current month into the database. From there, I want to archive them so I can go like

SELECT month,field,field,field FROM blog WHERE month='February'

The problem is that I don't want to list every month. Only months that are currently in the databse. i.e. Don't show up May, if there is no entry for May. I hope I am being clear. How might I go about doing this?

Thanks

[ReadMe.txt]

"select distinct month from table"

then use that to build your select box.

[SDP2006]

Works great, so far at least

Thanks