It's definitely not working. A resulting page breaks each time the code runs and I can see that the UPDATE operation has not taken place when I examine the data in the database. I know the problem is not with the resulting page because the page is built to handle NULL and I can see that the database has not been changed where I expect it to be. I even changed the column definition from smallint to varchar just to see if I was not permitted to set a smallint back to NULL, but the code didn't perform properly even when the column was a varchar. ARGH! Thanks for trying to help. This is so frustrating. > -----Original Message----- > From: Marco Tabini [mailto:marcot@inicode.com] > Sent: Friday, November 15, 2002 4:14 PM > To: Hutchins, Richard > Cc: php-db@lists.php.net > Subject: RE: Query Executes in MySQL Command Line, Not From > PHP. > > > Uhm... are you sure it's not working? It's an update statement, maybe > the row has already the NULL value before you execute the query? > > Otherwise, everything seems to be in order... sorry :-) > > > Marco > -- > ------------ > php|architect - The magazine for PHP Professionals > The first monthly worldwide magazine dedicated to PHP programmers > > Come visit us at http://www.phparch.com! > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php