Simplifying db queries

From: cruiserweight <bayon86_at_yahoo.com>
Date: 2 Mar 2005 01:28:00 -0800
Message-ID: <1109755680.603253.23410_at_o13g2000cwo.googlegroups.com>

I have many reports in the db, each one based on a week, month and year -- i.e, Jan 2005 Week 1 report. I want to display them by month, something like:

January
Week 1 report
Week 2 report
Week 3 report
Week 4 report

February
Week 1 report
...

And so on forthe complete year. Do I need to make 12 queries to the db, one for each month? Or is there some technique to handle these kinds of situations. Thanks immensely for any and all ideas. Received on Wed Mar 02 2005 - 10:28:00 CET