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

Solution to the FindControl problem
I have seen may posts about having problems with the FindControl method. Most seem to come about bec

code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page.

The pro

first few characters only
hi, does anyone know how to use PHP to take the first few words of a text and limit them? i have see

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

Multi Level Array Problem
hi all,

For example I have array like below:

$temp = array(array('north america', 'us'

problem when runing a funciton
I am trying to connect to database using a funciton in a functions.php

<?php
funct

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

Pagination won't carry results past page 2.
Hi all,

I've worked out my pagination script and its paginating fine until I click next from