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 helpppOrdernumber 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) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
