i have a table that gets its numerical values from the user to be stored but on the display table i need another table to sum the Columns of each field, how can i accomplish his i can provide examples of what i have

if I understand you right you have for example a table that has something like the following setup:

ID (primary key)
UserID
value1
value1

etc etc

and you would probably like to list something like the sum of all entries where UserID=1 for example ie many records within the table matching single id's etc.

so in the case of above you'd use a query something like

SELECT SUM(value1), SUM(value2) FROM `table` WHERE UserID=1

this would return you the sum of column value1 and value2 where the userid matches that of the input userid.

If you post the layout of your table and the columns you want the sum of I'll be able to provide you a more accurate statement but this should hopefully be enough to point you in the right direction