TalkPHP - View Single Post

Wildhoney · 07-20-2009, 10:51 AM

You could do it like so:

sql Code:

UPDATE
    marks
SET
    mark1 = (mark1 + 5),
    mark2 = (mark2 + 10)
WHERE
    id = 1

07-20-2009, 10:51 AM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	You could do it like so: sql Code: UPDATE marks SET mark1 = (mark1 + 5), mark2 = (mark2 + 10) WHERE id = 1 __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.