Individual Row Addition ((!!!help!!)

[Brian E Boothe]

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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]