Re: [PHP] HELP about pull hair on this INSERT

Didier McGillis wrote:

> ################################################## ###########
> MESSAGE:
> INSERT INTO group (id, bmenu, tmenu, parent, name, desc, g_desc,
> sort_order, status, image, mb, calendar) VALUES ('', '1', '1', '0', 'FBC
> Administrator', 'fdhsjfds jfdash', 'jhfdjs fjdsahfjksda hfjdsha fjdskah
> fjdsha fdshajf dsa h', '4', '1', 'fdjshafjdash', '1', '1');
>
>
> Invalid query: 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 'group (id, bmenu, tmenu, parent, name, desc, g_desc, sort_order
> ################################################## ############

GROUP and DESC are reserved words.

--
---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

PHP|Architect: A magazine for PHP Professionals – www.phparch.com