right now all the post are posted with the year 2011, so now for each post it post 2011 under the navigation bar.
Hopefully everything stated is clear.
<cfquery name="years" datasource="#dsn#"> SELECT year_posted, featured_posted FROM Featured_artist GROUP BY year_posted ORDER BY year_posted DESC </cfquery> <center> <cfoutput query="years"> <a href="feat_archived.cfm?yr=#DateFormat(featured_posted,'yyyy')#">#DateFormat(featured_posted,'yyyy')#</a> <br /> </cfoutput> </center>
the output show multiple year 2011 in stead of one.
I would like for it to be listed from the most recent year as below: