therealwesfoster Posted January 10, 2008 Share Posted January 10, 2008 I can't add any new rows, edit, remove or do anything with my table.. and I think it's because I have a column named "option". I've been able to rename them all except that one. I've tried it with MySQL Front and straight SQL through a PHP program and neither work. I can't delete/rename the column either. Whats the deal? This is the error btw 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 'option' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/85431-solved-cant-modify-table-because-of-column-name/ Share on other sites More sharing options...
revraz Posted January 10, 2008 Share Posted January 10, 2008 Use backticks around the field name `option` Quote Link to comment https://forums.phpfreaks.com/topic/85431-solved-cant-modify-table-because-of-column-name/#findComment-435872 Share on other sites More sharing options...
therealwesfoster Posted January 10, 2008 Author Share Posted January 10, 2008 Worked, thanks Quote Link to comment https://forums.phpfreaks.com/topic/85431-solved-cant-modify-table-because-of-column-name/#findComment-435876 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.