Addition of Rows

[Cooper94]

Is it possible to add the row values?

 

<?php
include 'db.php';
$sql = "SELECT * FROM pirerp WHERE status = '2'"; 
$result = mysql_query ($sql); 

while ($row = mysql_fetch_array($result)) 
{ 

$cargo = $row['cargo'];
echo $cargo;

}
?>

 

I am trying to add the values I can do "+=" but it gives me two values one added and one not. Thank you for your help!

[DavidAM]

<?php
include 'db.php';
$sql = "SELECT * FROM pirerp WHERE status = '2'"; 
$result = mysql_query ($sql); 

$cargo = 0;
while ($row = mysql_fetch_array($result)) 
{ 

$cargo += $row['cargo'];

}
echo $cargo;
?>

[Philip]

Or if thats all you want you can use SUM in MySQL:

 

$sql = "SELECT SUM(cargo) as sum FROM pirerp WHERE status = '2'";