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

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