18.12.2010, 22:42
Here is a suggestion for correcting query syntax - remember that all or none of these things may help, and that some of these things may not be needed, but on the other hand, they may fix your error.
I assume your Bought field doesn't have the space in it ( Bo ught )
try putting the database and table name in the query, and use those funny half quote things.
try adding spaces after your field names, before the = sign.
try the query with and without the punctuation around the field values (despite marcels post above)
Really you should be trying all these things yourself before posting on forums for help, but good luck anyway.
I assume your Bought field doesn't have the space in it ( Bo ught )
try putting the database and table name in the query, and use those funny half quote things.
try adding spaces after your field names, before the = sign.
try the query with and without the punctuation around the field values (despite marcels post above)
pawn Code:
UPDATE `database`.`table` SET `Int`= 6, `Vir` = 0 WHERE ...