fran Posted November 23, 2009 Share Posted November 23, 2009 $sql = "UPDATE books SET id = '$id', (etc...) READ= '$READ, CONDITION = '$CONDITION', (etc...) I have 29 fields to add to a MySql database. The problem is the two fields shown above. If I replace them with something else such as RD and COND, they work perfectly. Is there a list of words that are not allowed in PHP/MySql?l Quote Link to comment https://forums.phpfreaks.com/topic/182591-what-words-are-not-allowed-in-phmysql/ Share on other sites More sharing options...
Alex Posted November 23, 2009 Share Posted November 23, 2009 http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html http://php.net/manual/en/reserved.php Quote Link to comment https://forums.phpfreaks.com/topic/182591-what-words-are-not-allowed-in-phmysql/#findComment-963706 Share on other sites More sharing options...
premiso Posted November 23, 2009 Share Posted November 23, 2009 http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html Has a list of reserved words in MySQL, if you want to use them encase the reserved ones in backticks, however it is preferred to change them. $sql = "UPDATE books SET id = '$id', (etc...) `READ`= '$READ, `CONDITION` = '$CONDITION', (etc...) Quote Link to comment https://forums.phpfreaks.com/topic/182591-what-words-are-not-allowed-in-phmysql/#findComment-963707 Share on other sites More sharing options...
fran Posted November 23, 2009 Author Share Posted November 23, 2009 Well, thank you! This will save me from beating my head against a wall! Quote Link to comment https://forums.phpfreaks.com/topic/182591-what-words-are-not-allowed-in-phmysql/#findComment-963711 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.