[1jetsam]

I am using the define function to use as a prefix to database tables.

PHP Code:

define('SQL_PREFIX',''); 

Currently it is set to nothing, but it this database were to be shared with another program, you'd use something like "myprefix_".

Now here is the problem:

PHP Code:

$query = "INSERT INTO " .SQL_PREFIX. "user(user_username, user_password, user_type)

VALUES ('" .$_POST['username']. "', '" .$_POST['password']. "', 'admin');";

$result = mysql_query($query) or die(mysql_error()); 

And here is the error it turns out with:

PHP Code:

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(user_username, user_password, user_type) VALUES ('myusername 

This is really annoying me, and I'd like for it to work. Could someone come up with some solution, or tell me whats wrong.

[NeverMind]

put a space between the table name and the fields! and remove the semicolon from the statment

PHP Code:

$query = "INSERT INTO " .SQL_PREFIX. "user (user_username, user_password, user_type)

VALUES ('" .$_POST['username']. "', '" .$_POST['password']. "', 'admin')"; 

[1jetsam]

Ok that helps. It works now.

What I don't get is why that same code (without the prefix feature) worked before...

It doesn't matter.
Thanks again!