PHP/AJAX issue inserting to mysql database

Question

I'm having a problem inserting some data to a mysql database. I have used the same method with other features on the site, and this is the only one causing problems. It's meant to input into 3 field in the database (To, From, Message). As you can see it's a very basic messaging system.

I have the data coming into PHP via AJAX. But the problem is within the INSERT. I have messed around with it for over an hour now - no luck! Here is the code to insert:

mysql_query("INSERT INTO messages (To, From, Message) VALUES('$to','$loggedin','$message') ") 
or die(mysql_error());

And here is the SQL syntax 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 'To, From, Message) VALUES('Ryan','Ryan','hhh')' at line 1

I have tried adjusting a lot of things, no luck! :(

Mārtiņš Briedis · Accepted Answer · 2011-02-22 18:18:00Z

3

"TO" and "FROM" are reserved keywords, it's not wise to use them as column names. You have to escape them with a back-tick "`". Try this:

INSERT INTO messages (`To`, `From`, `Message`)

See the list with reserved words: http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html

answered Feb 22, 2011 at 18:18

Mārtiņš Briedis

17.9k5 gold badges59 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PHP/AJAX issue inserting to mysql database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related