summation values

[web_master]

Hi,

I got problem, how can I summary values in query?

 

In column `table_values` are different values (example; 10, 15, 24...)

$Query = mysql_query('SELECT * FROM `table` ORDER BY `table_id`');

if(!$Query) {echo mysql_error(); exit;}
while($REQUEST = mysql_fetch_array($Query)) {

$Values = $REQUEST['table_value'];


}

 

 

How can I summary values from rows?

(10 + 15 + 24 = 49)

 

Thnxs

[trq]

Your question doesn't make a great deal of sense with the example you have provided. Maybe....

 

$sql = "SELECT SUM(table_value) as tv_sum";
if ($result = mysql_query($sql)) {
  $row = mysql_fetch_assoc($result);
  echo $row['tv_sum'];
}

 

helps?

[web_master]

Your question doesn't make a great deal of sense with the example you have provided. Maybe....

 

$sql = "SELECT SUM(table_value) as tv_sum";
if ($result = mysql_query($sql)) {
  $row = mysql_fetch_assoc($result);
  echo $row['tv_sum'];
}

 

helps?

 

THNXS thorpe!!!