Update

[90Nz0]

This has been racking my brain all day, I just can't get this update to work....

UPDATE mKart
SET krtUsr = '$UsersID',
SET KrtProd = $ProdId,
SET KrtNum = KrtNum + 1
WHERE
krtUsr = '$UsersID'
AND
KrtProd = $ProdId

Please note, this message has been edited for seciruty, however, the same problem is shown here... just edited the vars.

[stolzyboy]

you only need to use the word SET once, comma-separate the rest

UPDATE mKart
SET krtUsr = '$UsersID',
KrtProd = $ProdId,
KrtNum = KrtNum + 1
WHERE
krtUsr = '$UsersID'
AND
KrtProd = $ProdId

[90Nz0]

Ah', cheers mate.