Alex1646 Posted March 30, 2011 Share Posted March 30, 2011 SQL Server Verison: 5.1.5.3 Raw SQL statement: INSERT INTO pm(to, from, message, date) VALUES('alex', 'alex', 'Bored!', '2011-03-30 04:30') Error statement: 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, date) VALUES('alex', 'alex', 'Bored!', '2011-03-30 04:30')' at line 1 I also went into the SQL demo in W3Schools (http://www.w3schools.com/sql/sql_tryit.asp) thinking it will give me more information. And I got this error message. Operation must use an updateable query. SQL structer: The table name is pm id int(11) to varchar(15) from varchar(15) message longtext date(datetime) I would like it to not give me a error message. Ive tried removing single quotes. Cant think of anything else to do. HELP! Quote Link to comment https://forums.phpfreaks.com/topic/232137-problem-with-insert-statement/ Share on other sites More sharing options...
trq Posted March 30, 2011 Share Posted March 30, 2011 Both to and from have special meaning in SQL, you should rename your fields to something better. Or, as a hack your can surround them in `backticks`, be aware however that this will only work with MySql. Quote Link to comment https://forums.phpfreaks.com/topic/232137-problem-with-insert-statement/#findComment-1194087 Share on other sites More sharing options...
lilnow Posted March 30, 2011 Share Posted March 30, 2011 INSERT INTO test.pm (`to`, `from`, `message`, `date`) VALUES ('alex', 'alex', 'Bored!', '2011-03-30 04:30:00') I agree with Thorpe, your table names could be better. Quote Link to comment https://forums.phpfreaks.com/topic/232137-problem-with-insert-statement/#findComment-1194435 Share on other sites More sharing options...
Alex1646 Posted March 31, 2011 Author Share Posted March 31, 2011 Thanks for the help. I have my private messaging system up and running now. Quote Link to comment https://forums.phpfreaks.com/topic/232137-problem-with-insert-statement/#findComment-1195075 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.