A
Anonymous
Guest
I hope someone can help me with this problem.
1] ...while ($r=mysql_fetch_array($res)){
$Total_Trailer = $r["Qt_Product"] * $r["Price_Ex"];
echo "".sprintf("%.2f",$Total_Trailer)."";
}
(I put Qt_Product, Price_Ex and Total_Trailer in a 3 colums table - of course I get at least 2 rows or more back in this table - )
2] what I need now is to make the sum of all these results the entire colum ($Total_Trailer) to get the "grand total".
I hope I've been clear enough, otherwise please contact me if you feel you need some more explaination / details...
Thanks to all of you.
Erick.
1] ...while ($r=mysql_fetch_array($res)){
$Total_Trailer = $r["Qt_Product"] * $r["Price_Ex"];
echo "".sprintf("%.2f",$Total_Trailer)."";
}
(I put Qt_Product, Price_Ex and Total_Trailer in a 3 colums table - of course I get at least 2 rows or more back in this table - )
2] what I need now is to make the sum of all these results the entire colum ($Total_Trailer) to get the "grand total".
I hope I've been clear enough, otherwise please contact me if you feel you need some more explaination / details...
Thanks to all of you.
Erick.