Re: insert NULL to mysql table.

From:	Pete Morganic	Date:	Wed, 02 Jul 2003 13:21:01 +0000
Subject:	Re: insert NULL to mysql table.
References:	1	Groups:	php.db
Request:	Send a blank email to php-db+get-29020@lists.php.net to get a copy of this message

'$issue'" where $editor = " is null" Anders Thoresson wrote:

Hi, I've the query "UPDATE un_issue SET i_editor = '$editor' WHERE i_date = '$issue'" where $editor = "/0" but the inserted value in un_issue.i_editor becomes 0. un_issue is defined as follows: CREATE TABLE un_issue (
    i_id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
    i_date DATE NOT NULL,
    UNIQUE (i_date),
    i_number INT,
    i_editor INT
); Isn't /0 the escapestring for NULL?