Hi guys, I've got this far with a bit of code:

<td><?php echo $Row03['QtyOrdered']; ?></td>
   <td><?php echo $Row03['Brand']; ?> <?php echo $Row03['ItemDescription']; ?></td>
   <td><?php echo $Row03['Price']; ?></td>
   <td><?php echo number_format ($Row03['QtyOrdered'] * $Row03['Price'],2); ?></td>

So, the user might see something like this:

Qty: Item: Cost: Totals:
2 Nescafe Classic 50g 2.50 5.00
1 McVities Hob Nobs 250g 2.33 2.33


Now, the above is embedded within a while loop pulling orders from a database but it only occured to me today, hey - what if the client select 2 of this and 1 of that. I need to total up these items.

So, as you can see, I can total up the rows, but I'm stuck on how I can total up the column "Totals"

Any help on this would be appreciated because I think it's my final stumbling block.

Hm,
I am not sure am I understand your question, but if you need total of last column (Totals) I think this script below will work for you if you insert in the while loop:

$totaloftotals = @$totaloftotals + $Row03['Price'];

Shivaji

Hi

Basically the last column does this:

SubTotal = Column 1 * Column 2

I then need to total all the SubTotals.

Do you think this will do it...?

Can anyone else help with this at all...?

<table>
<tr>
<th width="50">Qty:</th>
<th width="250">Item:</th>
<th width="25" align="center">Cost:</th>
<th width="25" align="center">Totals:</th>
</tr>
<?php
while($Row03 = mysql_fetch_array($Results03))
{
?>
<tr>
<td><?php echo $Row03['QtyOrdered']; ?></td>
<td><?php echo $Row03['Brand']; ?> <?php echo $Row03['ItemDescription']; ?></td>
<td align="right"><?php echo $Row03['Price']; ?></td>
<td align="right"><?php echo $SubTotal = number_format ($Row03['QtyOrdered'] * $Row03['Price'],2); ?></td>
</tr>
<?php
// Create Session Variable For Sum Total:
$SubTotals = array
(
$SubTotal,
);
foreach ($SubTotals as $SubTotal)
{
// Add Row Values Here For Totals:

***** this is where i'm stuck *****

}
}
?>
</table>

I'm sure shivaji's method will do just fine. Every time you calculate the total cost of one product in the loop, add that total to a "total of totals".

PHP Code:

$totalOfTotals = 0;
while(...) {
    $total = [some calculations];
    $totalOfTotals += $total;
} 


Hi guys

I've tried this:

<table>
   <tr>
   <th>Qty:</th>
   <th>Item:</th>
   <th>Cost:</th>
   <th>Totals:</th>
   </tr>
<?php
   while($Row03 = mysql_fetch_array($Results03))
   {
?>
   <tr>
   <td><?php echo $Row03['QtyOrdered']; ?></td>
   <td><?php echo $Row03['Brand']; ?> <?php echo $Row03['ItemDescription']; ?></td>
   <td align="right"><?php echo $Row03['Price']; ?></td>
   <td align="right"><?php echo $SubTotal = number_format ($Row03['QtyOrdered'] * $Row03['Price'],2); ?></td>
   </tr>
<?php
// Calculate Session Total:
   $GrandTotal = $SubTotal = number_format ($Row03['QtyOrdered'] * $Row03['Price'],2);
   $_SESSION['Total'] += $GrandTotal;
   }
?>
</table>
<p>Your Cart Total: <b>£<?php echo number_format ($GrandTotal,2); ?></b></p>

But it displays this:


So you can see, it's simply displaying the last item.

It's infuriating, I've tried clearing the session variable on loading the page and calculating it fresh, I've tried embedding the code inside the while statement and if the page refreshes it screws up.

So close...

Yet so far...

<p>Your Cart Total: <b>£<?php echo number_format ($GrandTotal,2); ?></b></p>

I think how is here your mistake. Try to echo here:

<p>Your Cart Total: <b>£<?php echo $_SESSION['Total']; ?></b></p>

Shivaji

The way you wrote your code you don't need your $SubTotal variable any more, since you save the same value in $GrandTotal. In other words, you replaced $SubTotal with $GrandTotal, without removing $SubTotal.

Instead, remove the $GrandTotal variable, because in your case the session variable ($_SESSION['Total']) is your grand total, or "total of totals".

Thanks for all your help guys, site's now live - just waiting to be paid