Hello, thanks for the quick input, that is what I already tried, I saw the WHERE command while searching for the other SQL entries.
UPDATE user SET vbookie_cash=500 WHERE userid=_____ does not work.
error number: 1054
error desc: Unknown column 'admin' in 'where clause'
--------------
I have gotten one step further by entering:
UPDATE user SET vbookie_cash=500 WHERE userid='accountname'
(adding single quotes around the userid)
However, that doesn`t give me the 1054 error, but will give me an affected rows of zero, no change to the user`s vCash. The userid is spelled correctly, obviously.
|