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
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 line 1
. 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: [PHP-DB] insert NULL to mysql table.
UPDATE