You are here: Re: mysql error (dash in table name)? « PHP Programming Language « IT news, forums, messages
Re: mysql error (dash in table name)?

Posted by Dave on 06/16/05 05:31

(el_roachmeister@yahoo.com) decided we needed to hear...
> How can I correct this error apart from eliminating the dash in
> United-Kingdom?
>
> Couldn't execute query 'SELECT * FROM United-Kingdom ORDER BY level
> DESC': 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 '-Kingdom ORDER BY level DESC' at line 1

Put back-ticks around the table name. Personally though, I'd remove
the dash and save the hassle of remembering the back-ticks.
--
Dave <dave@REMOVEbundook.com>
(Remove REMOVE for email address)

 

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

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