You are here: Re: Strange Behavior using MySQL « All PHP « IT news, forums, messages
Re: Strange Behavior using MySQL

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация