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 NO
net>cc:
Subject: [PHP-DB] insert NULL to mysql
table.
07/02/2003
UPDATE un_issue SET i_editor = null WHERE i_date = '$issue'"
Thanks. But how come this works and sets i_editor to NULL
"UPDATE un_issue SET i_editor = $editor WHERE i_date = \"$issue\""
but the following two gives me a sql-error "You have an error in your SQL
syntax near 'WHERE i_date = ' at lin
ry strings. I bet
it'll be dead obvious to you if you give that a shot.
Rich
> -Original Message-
> From: anders thoresson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2003 9:30 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: [P