Posts: 146
Threads: 8
Joined: Feb 2010
Reputation:
0
Delete ; at the end of every query.
Posts: 752
Threads: 87
Joined: Jul 2010
Reputation:
0
No luck ;/, any other ideas?
Posts: 412
Threads: 20
Joined: Mar 2009
Reputation:
0
The ; is fine. You didn't have to remove that. Here is your problem:
UPDATE users SET money = %d, score = %d, Shamal = '%d', Cargo = '%d', Helicopter = '%d', ban = %d, ban_reason = '%s', WHERE username = '%s'
Remove that comma at the end - it's not supposed to be there. It should be:
UPDATE users SET money = %d, score = %d, Shamal = '%d', Cargo = '%d', Helicopter = '%d', ban = %d, ban_reason = '%s' WHERE username = '%s'
Posts: 752
Threads: 87
Joined: Jul 2010
Reputation:
0
Cheers blacklite, that works perfectly.