Re: totalizing of Rows please help!!

[Peter Brawley]

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