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 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 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...) 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! 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
Archived
This topic is now archived and is closed to further replies.