Complicated

[Anon]

This question is complex, I've created a work sheet, that you fill in from various drop downs and then add hours and cost, but more than two people can work on one job at once. They both fill out the details from the drop down so it might look like:

John, cleaning, 1hour, £10
Dave, cleaning, 1hour, £10

except in a table format. Now i have a customer login area, which gives them details to what work has been done, but i don't want people to see each persons work, just a total, like

cleaning, 2hours, £20

but theres lots of things like that, and i want to just show one from each work related to that customer with a total for that price, the table then goes on to list the other work and has a total cost.

can anyone help?

thanks

[Anon]

Martin,

I think this is what you are trying to do:

worktable

action person time cost
cleaning john 1 10.00
cleaning dave 1 10.00

mysql query

$query = mysql_query("SELECT SUM(cost) AS totalcost FROM worktable WHERE action = '$action'");

$result = mysql_fetch_array($query);

print $result["totalcost"];

Hope this helps

Regards

Mike www.digitalegg.net

[Anon]

How do you store this information? if it is in a database then the solution is one simple sql statement.

[Anon]

Yep it's in a phpMyAdmin database