Adding values in a mysql database

Adam · 01-03-2006 05:52PM #1

I have a table, tbl_hours, which saves hours spent on a specific task into the field hours_spent, and also has a unique id hours_task_id. I want to create a page that will sum up the total hours for a specific task based on the hours_task_id.

So I will have a page listing existing tasks, from tbl_tasks, and when i click on a task it shows me a page that will give me details on the task, which i can select from tbl_task, and the total hours summed from the hours_spent field where the task_id = hours_task_id.

Am I making sense?

seamus · 01-03-2006 07:45PM

SELECT SUM(hours_spent) from tbl_hours WHERE task_id = hours_task_id GROUP BY hours_task_id

Should work.

Adam · 01-03-2006 07:57PM

And how would I print that in the table? I.e. the task name is printed out with:

print("<td> ".$row."</td>");

but how do I print the results of the sum() function?

seamus · 01-03-2006 08:00PM

Yeah, forgot that. It can be a bit finnicky. Easier to write

SELECT SUM(hours_spent) as total_hours_spent from tbl_hours WHERE task_id = hours_task_id GROUP BY hours_task_id

And then just use $row to output it.

Adam · 01-03-2006 09:45PM

Works a charm, cheers!

Adding values in a mysql database

Comments