Posted by Matt White on 05/05/07 15:30

Thanks a lot! It now works. I didn't know that there were reserved words
in MySQL.

"J.O. Aho" <user@example.net> wrote in message
news:5a2j3qF2mpuglU1@mid.individual.net...
> Matt White wrote:
>> Here is my query:
>>
>> $query = "UPDATE money SET value = '5' WHERE key = 'one'";
>
> As you been using reserved words as column name this is how the query
> should
> look like:
> $query = "UPDATE money SET value = '5' WHERE `key` = 'one'";
>
> Next time you create a table, do take a look at the page Veign posted and
> do
> not use those column/table names that are listed there.
> --
>
> //Aho

[Back to original message]