Math Op Addition of Values in repeated table

[gower]

I have a form on my site which allows the editing of a purchase order. These details are contained within a PO table. I have a double type value within this called total. Primary key is POID, a unique, autoinc value.

Also on this form, you are able to attach products to this purchase order. These products are entered into a products table separately when the order comes in. Various client required products may have to come from diff suppliers hence the PO's.

Once the product is attached to the PO, by a unique POID, it displays on this edit page in a repeated table, which shows all products with this POID value.

I need to somehow total the cost values of each product, from the product table, and have the total inserted into the total value for the purchase order they are attached to.

Best regards
This total will then be dynamically displayed on the generated PO ready for printing / faxing /emailing etc.

I -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[dreamers]

Try this code

SELECT SUM(price) as total FROM products WHERE POID = '$POID' GROUP BY POID

that should total up all items with that POID -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --