From: Peter Brawley
Date: April 25 2006 5:51am
Subject: Re: totalizing of Rows   please help!!
List-Archive: http://lists.mysql.com/mysql/197292
Message-Id: <444DB8F4.6020306@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Brian E Boothe wrote:
> i have three Values in each row of my MySQL database, im needing to 
> sum them in the table as they are displayed per Row ??   how do i do 
> this  ?
As Eugene said, VARCHAR values don't sum, since they are not numeric. 
Either cast the column values you wish sums of to a numeric type, or--a 
much better idea--correct your table structure.

PB

>


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.385 / Virus Database: 268.4.5/322 - Release Date: 4/22/2006