how about ....\0. yours is a foward slash not an escape. though that may
just be your post.... you can also use an unquoted NULL.
hth
jeff
anders thoresson
<listor@thoresson To: php-db@lists.php.net
.net> cc:
Subject: insert NULL to mysql table.
07/02/2003 08:59
AM
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?
--
anders thoresson
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
