Dear Alainq, > I am stuck on something, > I would like to summarize multiple columns to a total value in a query and > then display the output with php in a table. > the summarize works for 1 column but not for two or more. > any suggestions >?
So is what you are doing something like? (would it help to show us?) SELECT SUM( a ), SUM( b ) FROM tbl GROUP BY x; You can combine the two SUM()s easily (remember the result of SUM() is numeric): SELECT SUM( a ) + SUM( b ) FROM tbl GROUP BY x; Ok? =dn --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php