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

Posted by Veign on 05/05/07 02:24

Reserved words:
http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html

--
Chris
http://www.veign.com / http://www.veign.com/blog
--
"Matt White" <mgw854@msn.com> wrote in message
news:hWO_h.48$LJ3.27@trnddc02...
> Here is my query:
>
> $query = "UPDATE money SET value = '5' WHERE key = 'one'";
>
> When I run the page, the query dies saying:
>
> You have an error in your SQL syntax; check the manual that corresponds to
> your MySQL server version for the right syntax to use near 'key = 'one''
> at line 1
>
> The same thing happens when I use INSERT or other functions. I have used
> them before, but now I seem to be having troubles. Can anyone find any
> mistakes? I'm running XAMPP 1.6.0a on a Windows machine.

 

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

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