[bobster65]

Originally Posted by WhisperXBA

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.

that is because userid is a NUMBER, not the members name. use WHERE username='accountname'