Re: insert NULL to mysql table.

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: [PHP-DB] 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