|
Posted by peter on 04/02/07 00:40
> First of al thank you for your answers.
>
> I just changed the table column to another name (now temporaily called
> TEMP). Now it does update!!!
>
> It seems like "last_change" is some kind of protected name/variable.....
> or I dont know. BTW I use PEAR DB class.
>
> I dont know what exactly is causing this, but I am resolving for now by
> renaming the column so it will update.
>
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
The table is not a reserved word. However you should if at all possible
enclose table names in ticks (`) this would in the event of you using a
reserved word allow the sql to work.
Navigation:
[Reply to this message]
|