Re: Update Query Help...
| From: | 1LT John W. Holmes | Date: | Tue, 10 Dec 2002 20:34:10 +0000 |
| Subject: | Re: Update Query Help... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-24035@lists.php.net to get a copy of this message | ||
> I have definitely isolated the problem. If I change the column name
> that the match is being performed on from 'id-sys' to 'id_sys' I can
execute
> the query without having to worry about quoting the column name and
> everything works. I think that I am just going to leave the column name
> changed and take this as a lesson never to use '-' in a column name again.
> Thanks again for the help. Maybe we all learned something from
> this.
If you want to use a column name like id-sys, which you shouldn't, though,
as you've learned, you can enclose it in backticks, like
id-sys. Note that
those are not single quotes, they are backticks, to the left of the number 1
key.
---John Holmes...