A complex error to my script

[BlueFire2k5]

Originally Posted by TheMayhem

This is a registration script that I'm working on and I'm trying to test it on a fairly new mysql version but I'm getting this wonderful evil mysql error and was wondering what I could do to fix it. Anyways here is the sql error when executed.

PHP Code:

Invalid SQL: INSERT INTO user(username,email,password,joindate,usergroupid)
VALUES("Agroder","ilidercad@freemail.com","cc8965a7663a0fd1823537b4ee3140f5","1101269508","2")
mysql error: 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 'user(username,email,password,joindate,usergroupid)
VALUES("Agro 


And I've attached the file below.

INSERT INTO `user` (`username`,`email`,`password`,`joindate`,`usergro upid`)

Should do the trick. Note that 'user' is a function of mysql, so it thinks you're calling that function instead of saying insert into that database.

Cheers.