Add session variable from repeat fields

[billhobbs]

I have a page that repeats a table from my database. I add to fields from the table together to get a combined value with a a session name $charge . This table is repeated based on a common id. I need to add the $charge from each displayed fields to create another session variable called $totalcharges . How do I do this?

[billhobbs]

Here is a pic of what I'm trying to do.

$charge = $200.00  -- this is created by multiplying 2 other variables together

$charge = $500.00  -- this is created by multiplying 2 other variables together

 

Total charge should be $700.00

 

I can't use sum($charge) like I would normally do when I add fields from the database.

 

How do I add the 2 $charge values together?

[Drummin]

You could probably get the sum from the query itself SUM(field_name) or use another variable to add up these sub totals.

{//your loop
$total += $charge;
}

 

[billhobbs]

that didn't work. any other suggestions?