jonofat
asked on
How to total added loops
I have a small sum that loops for each individual item. Is there a way to total the subtotals though?
<?php
$theqty = $row_Recordset1['qtyy'];
$theprice = $row_Recordset1['qprice'];
$thetotal = $theqty * $theprice;
echo $thetotal;
?>
There is no loop shown in the code sample, so there would not be any subtotals.
ASKER
Sorry..
<?php $i=0; do { ?>
<tr>
<td class="bottomborder"> <input name="record[<?php echo $i ?>][qtyy]" value="<?php echo $row_Recordset1['qtyy']; ?>" size="1" />
x <?php echo $row_Recordset1['pdescription']; ?>
<input name="record[<?php echo $i ?>][productidd]" type="hidden" id="record[<?php echo $i ?>][productidd]" value="<?php echo $row_Recordset1['productidd']; ?>" /></td>
<td class="bottomleft">R <?php echo $row_Recordset1['qprice']; ?> x <?php echo $row_Recordset1['qtyy']; ?>= <span class="bottomborder">
R<?php $theqty = $row_Recordset1['qtyy'];
$theprice = $row_Recordset1['qprice'];
$thetotal = $theqty * $theprice;
echo $thetotal; ?>
ex. vat
<input name="totalprice" type="hidden" id="totalprice" value="<?php echo $thetotal; ?>" />
</span></td>
</tr>
<?php $i++; } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
How would the subtotals be grouped (what column name)?
ASKER
Well, it wouldn't be a column name I would use, wouldn't it be $thetotal ?
$thetotal = $theqty * $theprice;
which gives a subtotal for each line. But I need to add the subtotal of each line together. So if there are 3 individual products that look like this:
2 x $4 = $8
1 x $3 = $3
3 x $4 = $12
I somehow need it to add those up to give me $23.
I don't know if it would be some kind of foreach loop with $thetotal or what?
$thetotal = $theqty * $theprice;
which gives a subtotal for each line. But I need to add the subtotal of each line together. So if there are 3 individual products that look like this:
2 x $4 = $8
1 x $3 = $3
3 x $4 = $12
I somehow need it to add those up to give me $23.
I don't know if it would be some kind of foreach loop with $thetotal or what?
ASKER
I took a wild guess with this but it didn't get me anywhere.
$sum = 0;
foreach($thetotal as $value) $sum = $sum + $value;
echo $sum;
$sum = 0;
foreach($thetotal as $value) $sum = $sum + $value;
echo $sum;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tested it. Works perfectly. Genius! :)