how to sum the total of the column

[dreamy]

dear all,
can some 1 help me in saving the problem of

total all the amount
and print in a table form with all the detail?
using php and mysql.

thz.

[vikas1111]

@dreamy
Can you be more specific ?

[Dormilich]

tip: check out MySQL's SUM() function.

[dreamy]

ok,
i have try
<?
total=0;
$total += $row['amount'];
print $total;
?>

and it can total up all the value.
but it print every line.

how can i print under the column?

[Dormilich]

@dreamy
if you put the print command inside the while loop that's only natural.

using the sum() function in your sql query prevents that because you only have one "row".

[dreamy]

ok, i try it.
thz dormilich