Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 07-09-2013, 11:09 PM   #1
tux's Avatar
Join Date: Feb 2007
Location: Isle of Wight, that little island right at the bottom of the UK
Posts: 657
Default Select all events from Database and display separated by months

Hi All, need a bit of help with this.

I want to display a list of events from my database but separate them into sections for each month. ( see attached screen shot )

What would my logic be to accomplish this. I know how to get this result for the list from the DB but not sure how to separate the months in the same query, or would I have to query for each month? Or can I use a for each loop somehow.

My table currently has eventID, title, eventDate (in this format yyyy-mm-dd), timestamp

Hope this makes sense. Cheers, Paul
Attached Images
File Type: jpg events.jpg (33.5 KB, 6 views)
tux is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 03:22 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com