You are here: Re: PHP/SQL Question « PHP SQL « IT news, forums, messages
Re: PHP/SQL Question

Posted by Rik on 06/30/06 21:02

Andy Hassall wrote:
> On 30 Jun 2006 07:56:15 -0700, schaeffer.kyle@gmail.com wrote:
>
>> I'm getting the following error message while trying to update or
>> insert a record:
>>
>> 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 'create='Yes',edit='Yes',finalize='Yes',admin='Yes',config='Yes'
>
> CREATE is a reserved word.

Yup, IMO it's always a good idea to use backticks (``) around fieldnames,
even if they aren't reserved words.

Grtz,
--
Rik Wasmus

 

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

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