creating archives by month?

how to create archives file by months....
example for data from every month is listed

January
February
March
April
May
Jun

so when click onto either month it will display the data for that month only,

i'm trying to do this to a blog.can somehelp me?

Is it just me or is it recently that posters asking for help think everyone is a mind reader wow,

<sarcastic_rant>
sure thing I know how your dates a formatted, what database your using, I even know how you coded it all.
</sarcastic_rant>

erkkkk

any one here can read your mind 🙂 show code please thats what it mean

that's the nearest example i can give...i just wanted that kind of code.

create a link/ include a month=monthnumber in the link.

format month to include this year, into a timepstamp, create a timestamp for beginofmonth and end of month

In the database select * from table where datemonth =< endofmonth and datemonth >= startofmonth

echo out the results.