RE: [PHP-DB] Query Executes in MySQL Command Line, Not From PHP.
| From: | Hutchins, Richard | Date: | Fri, 15 Nov 2002 21:31:25 +0000 |
| Subject: | RE: [PHP-DB] Query Executes in MySQL Command Line, Not From PHP. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23405@lists.php.net to get a copy of this message | ||
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: [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 http://www.phparch.com!
>