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

How to display random record from table?
I have the following code:

Code: <?php
$display_block .= "<input type=

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

Getting Resource id #11 while trying to connect..
So i tried using "DEFINE" for the first time and im using the variables i defined to conne

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

list files from folder, only one for each date
I have many files in a folder and wish to only list one of each date

these are the file names

php title problem
Hi,

I am having a problem managing my page title with PHP.

Currently I have my <

Socket programming
Hello all,

I have a PHP socket script. GPS trackers connect to this socket. IMEI verification

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

Filename like the user name
I am creating a form and storing the values in file. Could anyone please tell me how to write a code

output printing as hexadecmal... XD
Everything works except the calcem call for the totusold and totuprice. The out put shows up as hex.