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@;]
> Sent: Friday, November 15, 2002 4:14 PM
> To: Hutchins, Richard
> Subject: RE: [PHP-DB] 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!

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to