Hi, Select Sum(ifnull(column1,0)+ifnull(column2,0)+ ...+ifnull(columnn,0)) From tbl group by ..
Anvar. At 11:34 PM 05/03/2002 +0100, you wrote: >Dear, > >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 >? >Thanks alot > > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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