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