building a text based game. flushed all the tables and i tried to sign up. i got this error and i cannot figure it out 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 'WHERE userid=1' at line 1 cant be in the php because it worked when i flushed the user table. but once i flushed it all it broke. probably something easy im missing.
can you post the query you're running? it clearly says that there's an error in that specific query. While you're at it, you might wonna post your table structure as well.
i corrupted something hardcore, i tried to fix it and everything exploded. theres a few things im going to try first
since i was just transfering from one server to another i decided to delete the db and folder and start over. will put be behind 2 hours of work but beats dealing with whatever i did. I dont understand what happened. i clicked "empty" for all tables, it went ok. then POOF. error. makes no sense. im going to try it again