[RESOLVED] While loop help

[7724]

Morning,

Say I have a simple while loop which loops seven times:

while ($row = mysql_fetch_assoc($result))  

    {
    $msg .= "Price: ".$the_price."\n\n";
    }

How could I say while the loop is running add all the values of $the_price together and at the end of the loop produce the following with the total assigned to a variable called $total_price?:

    $msg .= "Total Price: ".$total_price."\n\n";

[bpat1434]

Create a variable outside the loop that has a value of the integer 0. Then during each iteration of the loop, add $the_price to that variable. Then after the while-loop, echo out the total.

E.g.

$total = 0;

while($row = mysql_fetch_assoc($result))
{
    $msg .= "Price: ".$row['the_price']."\n\n";
    $total += $row['the_price'];
}

$msg .= "Total: ".$total."\n\n";

Hope that helps.

[7724]

Thanks :-)