Posted by Veign on 05/05/07 18:07

Safest thing is to assume there are always reserved words anything
development, which there are...

--
Chris
http://www.veign.com / http://www.veign.com/blog
--
"Matt White" <mgw854@msn.com> wrote in message
news:pq1%h.477$wy2.253@trnddc03...
> 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]