[Murty]

put that in and replaced #USERID# with the users id, and it came back saying:

Error

SQL query:

UPDATE `user` SET `post_thanks_amount` = '0' WHERE `userid` = '149' LIMIT 1 ;

MySQL said: Documentation
#1054 - Unknown column 'post_thanks_amount' in 'field list'

its ok i ended up doing it this way and it worked.
UPDATE `post` set `post_thanks_amount` = '0' WHERE `userid` = '#USERID#'
thanks for your help