Hi there,

I've just finished building a simple news application foir my website, but I'd like to change the way the news items are displayed in the list.

What i'd like to do is seperate them into months, how the hell would I do this? I've got an idea, but not too sure, would it something like this:

• Order them by date decending
• find current month
• loop for each month
• loop for each news item in this current month
• move forward a month

Thanks :)

The only thing I might add would be to only select items whose date was =/> current month and have the query do the sort - saves the 1st two steps. You'd also want the sort to be ascending - lowest date to highest.

Also would need to figure how to handle months (including current) with no news items - e.g. skip, display month header and a message, etc.

EDIT: One of the numerous Calendar/Event applications rhat display a month at a time will have code very similar to what you want to do.