Summing rows and colums in mysql 5.0 heeelllppp!!

2006-10-20 Thread Brian E Boothe
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

Re: Summing rows and colums in mysql 5.0 heeelllppp!!

2006-10-20 Thread Dan Buettner
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