[SOLVED] GROUP BY date

[icuucme]

Date                      amount 

02/21/08                  600   

02/21/08                  100

02/22/08                  300     

02/23/08                  500   

02/23/08                  700   

02/25/08                  200

 

Let's say i want to do a report that totals the the amount per day

 

Date                      amount 

02/21/08                  700   

02/22/08                  300     

02/23/08                  1200   

02/25/08                  200

 

Is there anyway to do a GROUP BY date?

 

 

[fenway]

Sure, use a SUM() and group by date... assuming, of course, that you've stored dates properly.

[icuucme]

yea thanx, i donno y i didnt think of that :S