Posted by J.O. Aho on 05/05/07 05:29

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]