From: Peter Brawley
Date: April 24 2006 6:39pm
Subject: Re: totalizing of Rows   please help!!
List-Archive: http://lists.mysql.com/mysql/197283
Message-Id: <444D1B5C.9070208@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Brian,
>
> 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  ?
>
> Projectname     Elecremain   Controlremain    
> otherremain               <?php ?>
> Project1             2300             1600                     
> 250              <?php  (Sum) ?>
> Project2             4300             600                       
> 150             <?php  (Sum) ?>
In the query, with something like ....

SELECT
  elecremain,
  controlremain,
  otherremain,
  elecremain+controlremain+otherremain AS SumRemain
FROM ... etc

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