How to calculate the sum of the values in a loop

[dobsun]

MY QUESTION: HOW TO SUM TOTAL VALUE OF ALL ROWS?
MY CODE:

<?
$q="SELECT * FROM product ";
$r=mysql_query($q);
$num=mysql_numrows($r);
?>
name,instock,unitprice,value
<br>
<?
$i=0;
while ($i < $num) {
$name=mysql_result($r,$i,"name");
$instock=mysql_result($r,$i,"instock");
$price1=mysql_result($rsklad,$i,"price1");
echo $name;
echo "/";
echo $instock;
echo "/";
echo $price1;
echo "/";
echo $value=$instock*$price1;
echo "<br>";
++$i;
} 
?>

MY QUESTION: HOW TO SUM TOTAL VALUE OF ALL ROWS?

$total = sum($value);

???

[pbmods]

Heya, Dobsun. Welcome to TSDN!

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

Please use CODE tags when posting source code:

[CODE=php]
PHP code goes here.
[/CODE]

[dobsun]

Actualy I don't have problem to sum rows in mysql, I could sum it like this :

$q1="SELECT  sum(productsum) as a FROM product ";
$r1=mysql_query($q1);
$a= mysql_fetch_array($r1); 
echo $a['a'];
 

My problem is to show the SUM of all variables $value, see 1st post;
One sugestion is to make as follow:

 $value[$i]=$instock*$price1;

But now I must calculate ... something lake this:

$total=$value[0]+$value[1]+.....+$value[$i]; 

How to calculate atomatic??

[pbmods]

Heya, Dobsun.

Alrightey. Changed thread title.

Try creating a variable to store the total:

$total = 0;
while( ... )
{
    .
    .
    .
    $total += $value;
}
 

[dobsun]

DONE thank you! correct one:

<?
$q="SELECT * FROM product ";
$r=mysql_query($q);
$num=mysql_numrows($r);
?>
name,instock,unitprice,value
<br>
<?
$i=0;
while ($i < $num) {
$name=mysql_result($r,$i,"name");
$instock=mysql_result($r,$i,"instock");
$price1=mysql_result($rsklad,$i,"price1");
echo $name;
echo "/";
echo $instock;
echo "/";
echo $price1;
echo "/";
echo $value=$instock*$price1;
echo "<br>";
$total=$value+$temp;
++$i;
$temp=$total;
} 
?>

Work for me!

[pbmods]

Heya, Dobsun.

Glad to hear you got it working! Good luck with your project, and if you ever need anything, post back anytime :)

[karlectomy]

wow just shows me how I take simple algorithms for granted...

[karthick raja]

$tot=0;

for($i=1;$i<=10;$i++)
{

$tot=$tot+$i;

}