Why does SELECT SUM(column1 + column2 + column3) AS combined FROM table
not work for you? The php echo is no different from any other data... your column name is "combined" if you fetch_array or fetch_assoc. Please post more information if this does not accomplish what you require. Cheers, # Nathan ----- Original Message ----- From: "Alainq" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 05, 2002 3:34 PM Subject: Summarize 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