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

mysql VARCHAR acting like INT
Hi, All.

I have a table that contains a varchar(10) column named weird_field. In this column

My XSRF Prevention code isn't working
First of all, thanks for the generous help you guys have given me in the past on this forum.
Seco

help removing unwanted graphic
How do I remove the small elongated rectangular shape between the "Latest post" and "

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place

Web Host List
Here is a list of web hosts that offer PHP and MySQL. It is no where near a full list, but it is mos

Any help with my email script?
I have an email script, I have not tested it, although someone tested it for me and said it worked f

Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to a

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q