Help with array!!

[mparab]

Hi,

Here's what i'm trying to do. I have an sql select statement with a date(between) in it. What my boss wants is to take this date range and then total the number of hours for each day base on a status, ie, work, vacation, etc. I can get the date range fine, but i don't know how to total based on per day without selecting each date individually. I know how to do it for the entire range but not individual day. Any takers on this one.

Thanks in advance,
M

[coreyp_1]

SUM() is an aggregate function, so just GROUP BY the date