Grouping MySQL Timestamp (12) by year.

[Anon]

Hi,

I use the MySQL Timestamp (12) which is in the YYMMDDHHMMSS format.

I need to list my archives by month or at the very least by year.

Is there a way in which I can group the articles by month and year?

example:

May 2001
Article 1
Article 2

April 2001
Article A
Article B

[[deleted]]

That is not grouping, that's just printing the month in front of the data.

When you do a query and use "ORDER BY date_field"
you already get the records in the right order.
What you have to do in PHP is:
- Do the query
- start a loop that will print all the months you want to print.
- - print the first date
- - check if there are more records in the resultset
- - - if yes, check if the record should be printed for this month
- - - - if yes, print it and move to the next record from the resultset
- - - - if no, move to the next month
- - - if no, move to the next month
- end loop

[Anon]

Thanks a lot,

I wasn't sure how to go about it. I was thinking I would probably need to have a query for each month, but that would be too much work.

Thanks again.