Hi guys, I am trying to insert a NULL value into a DB field. The value is not always NULL so the statement is given. Unfortunatelly it is inserting 0 instead of NULL.
How can I get the thing going with NULL??? Here is the code I am using: if ($park == 'false'){ $park = NULL; } $stmt = "INSERT INTO $T1 ( belongs_to, name, caption, country, province, city, glacier, park, lake, mountain, beach, comment, keywords, date_taken, date_posted ) VALUES ( '$user_id', '$picture', '$caption', '$country', '$province', '$city', '$glacier', '$park', '$lake', '$mountain', '$beach', '$comment', '$keyword', '$date_taken', '$date_posted' )"; Cheers Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]