Mysql, adding up query results

[jasmine_davis]

Hi,

I am stuck with a simple task of adding up a set of numbers that are the result of a mysql query. For example, I have a set of records that are the log of hours I have spent on doing different tasks, in the format of 0.25, 0.5, 0.75, 1.0, 1.25, etc. What I need to do is after querying the database, I need to add them up into a total figure, for example, like "12.0" hours for display on the page.

Please can anyone help me with this?

Thanks in advance,

Jasmine

[tasistro]

how bout

SELECT sum(%hour_field%) as total_hours WHERE %criteria%;

Saludos
Gerardo

[jasmine_davis]

Thank you so much for this piece of info. It worked like a charm.

Thanks again,

Jasmine