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

uploading video files into mysql in php
hi,
I have the video files which i have to upload into mysql db. along with creating thumbnails f

php/xmlrpc class issue
I am working on xml-rpc in php to start with.

I have a class that only has variables defined

Preventing SQL Injection
I have a question about SQL Injection, In some of our code we use this: view plaincopy to clipboa

Simple image grab script.
I was wondering if it was possible and if anyone knew how to make a simple php script that looks at

Return X values where an ID number doesnt matter
Well as for subject heading, thats the best i could think of.

Currently im having a problem w

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

downloading a file as HTML
Hi.
I'm rather confused with forcing a download. I just want to save dynamic content (from $_SESS

array_map() probably obvious mistake
The code below is part of a class to escape strings, but should also accept an array, using array_ma

Gerenate tabel in Php
I whant to generate a tabel takeing data from database like this one so the results to be display on

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc