Add two columns in a single row and replace sum in col B.

[system]

For example.

My sql table looks like this:
id name new_pts old_pts etc…
1 Bob 4 7

I want to replace old_pts with the total of nw and old pts.
I’m new to PHP and I’m stuck, my way does not work. Can someone at least guide me through this?

Thanks

[Topcoder]

This should do it… Just replace tablename with your table name.

[php]Update {tablename} set old_pts = old_pts + new_pts;[/php]