Re: UPDATE multiple columns, returning an error?
| From: | Jason Wong | Date: | Tue, 22 Apr 2003 12:45:52 +0000 |
| Subject: | Re: UPDATE multiple columns, returning an error? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27253@lists.php.net to get a copy of this message | ||
On Tuesday 22 April 2003 18:24, John W. Holmes wrote:
> > Database Error: 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 'dec='' WHERE id='1'' at line 1
>
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html
> #Reserved_words
>
> DEC is a reserved word. Choose another column name.
Or enclose it with backticks (`):
UPDATE software SET title='$ud_title',
dec='$un_dec' ...
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
Have no friends not equal to yourself.
-- Confucius
*/