[SOLVED] pm script issue

[Zeradin]

I really have no idea what the hell is wrong here

 

I get this error:

 

INSERT INTO pms (to, from, contact, title, message) VALUES ('7', 'asdf', 'asfd', 'sdf', 'asdf')
Error in query: . 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 'to, from, contact, title, message) VALUES ('7', 'asdf', 'asfd', 'sdf', 'asdf')' at line 1

 

when i try to insert using this:

 

$pmquery = "INSERT INTO pms (to, from, contact, title, message) VALUES ('$userid', '$name', '$email', '$title', '$message')" or die ("Error in query: $pmquery. ".mysql_error());
echo $pmquery.'<br />';
$pmresult = mysql_query($pmquery) or die ("Error in query: $pmresult. ".mysql_error());

 

I must be making some sort of crazily obvious mistake, but it's driving me insane. what could possibly be wrong at (to, ?!

 

table pm is id, to, from, contact, title, message, read, mpm, timestamp

 

thanks again

[php_dave]

Hey

 

to and from are reserved words in mysql  - change to:

 

INSERT INTO pms (`to`, `from`, `contact`, `title`, `message`) VALUES ('7', 'asdf', 'asfd', 'sdf', 'asdf')

 

this will get the query working but I would rename those fields to something else