RE: [PHP-DB] NULL VALUE
| From: | Norland, Martin | Date: | Mon, 03 Jan 2005 18:40:41 +0000 |
| Subject: | RE: [PHP-DB] NULL VALUE | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37956@lists.php.net to get a copy of this message | ||
> -----Original Message-----
> From: Jochem Maas [mailto:jochem@iamjochem.com]
> Sent: Monday, January 03, 2005 12:16 PM
> Subject: Re: [PHP-DB] NULL VALUE
>
> LightBulbMoment (tm): 5 seconds of searching on the MYSQL site tells
me
> STATUS is a keyword. try either renaming your field or using backticks
> to escape the name e.g.:
http://dev.mysql.com/doc/mysql/en/Reserved_words.html
doesn't list
status, although I am familiar with its various forms e.g. "show
status".
You're probably right, but I don't exactly see this as a 'clearly
documented'. Still, backticking all field names is a good idea anyway.
Builds character.
Cheers,
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.