> http://www.mysql.com/doc/en/Reserved_words.html > > [snip] > 6.1.7 Is MySQL Picky About Reserved Words? > > A common problem stems from trying to create a table with column > names that use the names of datatypes or functions built into > MySQL, such as TIMESTAMP or GROUP. You're allowed to do it (for > example, ABS is allowed as a column name). However, by default, > in function invocations no whitespace is allowed between the > function name and the following `(' character, so that a function > call can be distinguished from a reference to a column name. > [/snip] > If you keep scrolling on the page you gave the link for, you'll get to a list of reserved words and notice that timestamp is not reserved. In fact if you scroll even farther, you will see that it is explicitly allowed in mySQL, but that doesn't mean using it is a good idea.
> try renaming the field timestamp to something else and see if that helps? > If you are using a reserved word and renaming is not an option you can use the backtick operator ` to escape it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
