Php/MySQL Group by month and year?

[jdk]

I have a database of information of sales per month for the last few months. I am looking for a script in Php that will start will search a mysql database table for a list of months and years. It will then start with the oldest and print out the information.

2009-Oct
1. Sale $100 10/1/2009
2. Sale $200 10/2/2009
3. Sale $75 10/5/2009

total $375

2009-Nov
1. Sale $50 11/15/2009

total $50

2010-Jan
1. Sale $50 1/1/2010
2. Sale $30 1/5/2010

total $80


I can show you what code I have so far. I am willing to pay so let me know what your price is. I am looking to have this done within the next day or so.

 

[stscac]

Check out stack overflow - they have some good stuff
MySQL Query GROUP BY day / month / year - Stack Overflow

-Steve

 

[jdk]

Thanks. Using that and a couple of other resources, I have figured out another way of doing what I wanted to do. If I decide to go back to the original way, I will reply to the PM's sent to me. Thanks all!