calculating date values

[dude333]

Hi,

I want to add all the time values from one column in a table for the last 7 days of entries.

Can anyone tell me the most effective way of doing this, is there a quick an easy wy to do this with mysql or is it better to write a php function.

Thanks.

 

[vanekl]

SELECT sec_to_time(sum(time_to_sec(yourfield)))
FROM yourtable
WHERE yourdatefield >= DATE_SUB(CURDATE(), INTERVAL 7 DAY));