List:General Discussion« Previous MessageNext Message »
From:Nicolas Verhaeghe Date:April 25 2006 6:56am
Subject:RE: totalizing of Rows please help!!
View as plain text  
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) ?>


----------------

Select
a,b,c,
a+b+c as GrandSum
From
`table`

Try next time to give a name to your table and to use simpler field names,
like a, b, c, etc...

No need to group, here, really. 

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