List:General Discussion« Previous MessageNext Message »
From:Barry Date:April 25 2006 7:46am
Subject:Re: Individual Row Addition ((!!!help!!)
View as plain text  
Brian E Boothe wrote:
> 
> well i have this       $sql2="SELECT ordernumber,Elecrem, CtrlProjrem, 
> OthrProjrem SUM(Elecrem+CtrlProjrem+OthrProjrem) AS btstotal9 FROM 
> orders GROUP BY ordernumber ORDER BY ordernumber";
>      only add's up the first row it hits and adds it to the remaining 
> rows ,,
> 
>    I need individual Row Addition!!!!
>       Please helppp
>    Ordernumber        Elecrem,   CtrlProjrem,    OthrProjrem   
>        12311314            234             123                
> 123              =  <? row ?> =  480
>        12354314            100             123                
> 123              =  <? row ?> =  346
> 
> 
You forgot some exclamation marks. here i give you some:
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

That should fit you.

-- 
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
Thread
Individual Row Addition ((!!!help!!)Brian E Boothe25 Apr
  • Re: Individual Row Addition ((!!!help!!)Barry25 Apr