List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:April 25 2006 5:51am
Subject:Re: totalizing of Rows please help!!
View as plain text  
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

Thread
totalizing of Rows please help!!Brian E Boothe24 Apr
  • Re: totalizing of Rows please help!!Eugene Kosov24 Apr
  • Re: totalizing of Rows please help!!Peter Brawley24 Apr
  • Re: totalizing of Rows please help!!Peter Brawley25 Apr
  • RE: totalizing of Rows please help!!Nicolas Verhaeghe25 Apr