> -----Original Message----- > From: Jochem Maas [mailto:[EMAIL PROTECTED] > 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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
