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

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

mr8m - reverse document
Friends,

I'm trying to reverse a document held by MIRO, but it reports the message balan

Firewall / visited websites logger
Hi. I have a firewall implementation and I want to log all the websites visited on the machine. S

wav to mp3 + goDaddy
I need to convert wav files to mp3s. From what I have found so far one way to do it is to have my PH

ereg_replace issue
hi there people

i have this code happening with regards to my wamp server. is this something

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

CURL question
i am wondering if it's possible to use multi curl with login something like

login once to web

Switch letters in message (basic cryptology)...
I am trying to switch letters around in a message for an application on my site (see here). The prob

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