[snip] i wanna be able to sum a colum in a mysql database and display the sum
on the page field name <"Bondrem"> so if someone adds to the database the bondremaining colom would add together and show the total on the page record1 - ["bondrem"]=100 record2 - ["bondrem"]=450 total bondrem on page would show 550 can anyone help me > [/snip] Yes, someone can help you. SELECT SUM(`column`) AS total FROM table; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]