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

php and downloading
I want to use a php script to create two files. Then I want it to redirect (or whatever) to have tho

Procedure with variable number of columns
Hi, I have a procedure that looks like this:

PROCEDURE PROC(p_cursor OUT sys_refcurso

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Echo multiple lines of html code
Hi guys,

I would like to know if there is a way to echo multiple lines of html codes.

TabControl Inside ListView Not Editing
Hello everybodyI have a ListView on my page. Inside the ListView I put a TabControl, cuz I want to p

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

Date/Time and Checkbox
Hi Everyone,

I am trying to figure out how to insert the current date and tim

Curl timeout breaks script
So im having difficulties with skipping timeout error in curl
my script calls different functions

Embed Video Problem
Hey, thanks for looking!

File to be embedded:

Code: <playlist version="1&q

Please help - should be a simple fix.. driving me nuts
Everything seemed to be working fine. I have a table, it alphabetically lists a bunch of cities and