Forum :: Programming :: MySql Syntax Error [Solved]

Well ive been messing with this for over 2 hours but i cant figure it out. Every time i use this mysql query (Note: this only started happening after i added the Join Value, a Datetime column)

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 'join) VALUES ( 'username', 'HashedPasswordHere', 'a_choate@live.co' at line 1

Here is the the code im using.

"INSERT INTO `users` (username, password, email, admin,id, join) VALUES ( '".$Safe_Username."', '".$Safe_Password."', '".$Safe_Email."', '0', '".$ID."', NOW())"

Ive used CURDATE(), NOW(), and the PHP date function but none of them have been successful.

Fixed it.

---
Andrewbob - I would be on the fucking copter of rofls

Programmer, Web Developer, and Graphics Designer