insert NULL to mysql table.

[anders thoresson <listor@thoresson.net>]

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