Get Total From While Loop

Posted on 16th Feb 2014 07:03 pm by admin

I'm trying to get the total for each product and add them for a Grand Total to list outside the loop or only echo once I can do the addition but it will echo 5 time in the loop.
How would I go about doing this?
Thanks in advance for your help.
Code: <?php

$cart2="SELECT * FROM products WHERE pro_indid='glass'";

$res2 = mysql_query($cart2) or die('Error, query failed 2');

while($cr2=mysql_fetch_array($res2)){

$totrow=$cr2["total"];
///the $totrow will echo below 5 time each price in database 5.67 which the total should be 28.35 //
echo $totrow;
}

///Output of total would be $28.35

?>
The output I'm looking for would be like so

5.67
5.67
5.67
5.67
5.67

GrandTotal:28.35

Your Answer:

Login to answer

Other forums

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

Vertical Alligning - Not working in 1 cell?
<?php

echo "<table id="valign" width="60%" style=

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

php + mysql count consecutive data
I have a database of values and I want to work out how to display them if the values match a consecu

pagination - need help on passing of search query.
Hi, i have been trying for days but couldn't get this sorted out. Would like some professional help

1,000 select boxes with 100 options?!
I have 1 drop down select box with 1,000 options.


In some case, there will be 100+ of the