I have an SQL syntax error in my database, need help correcting it?

My habbo retro stills works, thats not a problem at all. Im using a phoenixEMU.
The problem is stated in the "users" section of the database. It states:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`2000` WHERE `Sin`' at line 1

By the way, Sin is my user name. What can I do to fix
______________
Here is the picture:

Attachment 115618

I can still register an account, and it would be able to access the hotel, but if I am not mistaken, shouldn't of the field boxes disapear by now? It was like that with my holocms hotel, as soon as I register an account the field boxes would disapear, and it would show the users information and email etc.

What exactly were you trying to do?

Keep track of recorded users who register.

If you go into the users table then click 'browse' it will show you all registered users.

Nothing appears still.

Quote:

---

Originally Posted by Sin0xFF

Nothing appears still.

---

Hmm, Ive never heard of that happening before o.o

Ok weird, but if I type in: SELECT * FROM `users` WHERE 1 It eventually goes into the users content, but then once I exit off, it continues to display the Error message. Thats means if i wanted look at the recorded database of users I would have to keep typing in SELECT * FROM `users` WHERE 1 :(

as I've said try this;

UPDATE `users` SET `rank` = '2000' WHERE `username` =Sin;