adding database information using php

[Overkill]

ok... I am not a programmer... ( i am self taught.. i working with Php) i have data , numbers to be exact in a mysql database

i can pull the data out, but what i want to know is how can i get each data to be added to the next and then displayed as a sum

extract:

//query database
$gas_b = "Select number from $dbase_table3";
$gas_b_q = mysql_query($gas_b);

//pull data
$inc=0;
while ($row = mysql_fetch_array($gas_b_q)) {

$bought = $row["amount_bought"];
}

$result[$inc]=$bought;
$inc++;


and to display it as a list

extract:

for ($k = 0; $k <= count($result); $k++) {
echo $result[$k];}

this what i have.. (what i use to pull out data and display as list) anyway.. i want to take number out and add them together and display only the sum

how would i change this script to instead of listing i could just add them together

and then just print the sum..

some Help

[death_knight]

$sum = 0;
for ($k = 0; $k <= count($result); $k++) {
$sum = $result[$k] + $sum;
}

echo $sum;

[aonekilla]

well.. there are two ways you can approach this... the first is by making the database do the calculation for you via a select statement then just print the output:

$res = mysql_query("SELECT SUM(amount_bought) AS total FROM what_ever_table");
$row = mysql_fetch_array($res);
echo "SUM is $row[total]"; 

OR
the second method is to use PHP code to carry out the calculation:

$total = 0;
foreach($result as $val){
     $total += $val;
}
echo "SUM is $total"; 

But i hope that you know that the code you have up there has some bugs that need to be fixed.
1. The $inc variable is supposed to be in the while loop
2. The sql statement you have there will cause PHP to generate errors because the field(number) specified in the SQL statement will not be present in the associative array - $row.

[owen]

<?php 

print( array_sum($a) ); 

?>

[Overkill]

well.. there are two ways you can approach this... the first is by making the database do the calculation for you via a select statement then just print the output:

$res = mysql_query("SELECT SUM(amount_bought) AS total FROM what_ever_table");
$row = mysql_fetch_array($res);
echo "SUM is $row[total]"; 

OR
the second method is to use PHP code to carry out the calculation:

$total = 0;
foreach($result as $val){
     $total += $val;
}
echo "SUM is $total"; 

But i hope that you know that the code you have up there has some bugs that need to be fixed.
1. The $inc variable is supposed to be in the while loop
2. The sql statement you have there will cause PHP to generate errors because the field(number) specified in the SQL statement will not be present in the associative array - $row.

Thanks... the filed number .. was a mistake .. it was actually amount_bought

but anyway. . that i go it to work... using this
as u stated

extract

$gas_b = "Select sum(amount_bought)AS Total from $dbase_table3";
$gas_b_q = mysql_query($gas_b) or die(mysql_error());
$result = mysql_fetch_array($gas_b_q);

echo $result['Total'];

Thanks.. but question.. is there a difference in having your database do the calucalation as to doing using php

[owen]

Thanks.. but question.. is there a difference in having your database do the calucalation as to doing using php

the database is always much much much faster because it is better at handling the data