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]

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.

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]

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

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