Something like this should work if you want to do it in SQL:
SELECT a, b, c, a+b+c FROM table <where clause> UNION ALL SELECT SUM(a), SUM(b), SUM(c), SUM(a+b+c) <where clause> Dan On 10/20/06, Brian E Boothe <[EMAIL PROTECTED]> wrote:
How can I keep a running sum of the values in rows as well as columns in a > mysql database and display them,, > Can someone show examples of this thanks > > > Value1 12 14 34 Sum > -- > Value2 14 23 45 Sum> -- > > Sum > -- -- -- -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.408 / Virus Database: 268.13.8/489 - Release Date: 10/20/2006
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]