[PHP-DB] Re: insert NULL to mysql table.

[Pete Morganic]

> '$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?



--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php