actually, try using $park = "NULL" instead go $park = NULL; in php NULL is the same that "" which is the same that 0
> ----- Original Message ----- > From: "Rick Emery" <[EMAIL PROTECTED]> > To: "'Andy'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, February 01, 2002 7:51 AM > Subject: RE: [PHP-DB] Inserting NULL values does not work > > > > Your problem is that you've included the value of $park in single-quotes. > > Therefore, because it contains NULL, i.e., \0, this is translated to '0' > in > > the INSERT statement. You must make your test prior to the INSERT > statement > > and use the proper $park value. > > > > Or, you can: > > > > if ($park == 'false'){ > > $park = NULL; > > } > > else{ > > $park = "\"$park\""; > > }; > > > > in you INSERT statement change: '$park', to $park, > > > > -----Original Message----- > > From: Andy [mailto:[EMAIL PROTECTED]] > > Sent: Friday, February 01, 2002 9:43 AM > > To: [EMAIL PROTECTED] > > Subject: [PHP-DB] Inserting NULL values does not work > > > > > > 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] > > > > -- > > 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] > > > -- 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]