Adding together

[Anon]

Hi, i'm trying to add some prices together,

$query = mysql_query("SELECT SUM(cost) AS totalcost FROM workdetail WHERE aircraftreg = '$regcode'");

this is one of the codes that works great however i have another one that adds the cost from a different table. This also works so i have two prices one for labour, the other for cost i just wont to add the two together to give an over all price.

Hope you can help, thanks Martin

[Anon]

If your tables both contain the "aircraftreg" then you can probably use a JOIN to merge the two tables in your query and get both sums at the same time.
If not, you'll have to add the results manually.

[Anon]

thanks Vincent it works now.