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
Navigation:
[Reply to this message]
|