A complex error to my script

[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.

And I've attached the file below.

[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.

[TheMayhem]

When i changed this...

I get this wonderful error

Parse error: parse error, unexpected T_STRING in /home/nodq/public_html/newuser2.php on line 240

[BlueFire2k5]

Originally Posted by TheMayhem

When i changed this...

PHP Code:

$sql = "INSERT INTO " . TABLE_PREFIX . "user(". implode(',', $names) . ")
VALUES(". implode(',', $values) . ")"; 


to this

PHP Code:

INSERT INTO `user` (`username`,`email`,`password`,`joindate`,`usergroupid`) 


I get this wonderful error

Parse error: parse error, unexpected T_STRING in /home/nodq/public_html/newuser2.php on line 240

Err, you must not be a programmer. Sorry, I didn't know.

Here:

PHP Code:

$sql = "INSERT INTO `" . TABLE_PREFIX . "user` (". implode(',', $names) . ")
VALUES(". implode(',', $values) . ")";