It's not failing on the single-quotes. MYSQL can use single-quotes. -----Original Message----- From: Oliver Cronk [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 10:01 AM To: Php-Db ML; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Inserting NULL values does not work
Why not make it a function which also checks and replaces for characters SQL fails on eg if ' replace with '' in strings etc, and does any sanity / validation checks at the same time? Ollie "Rick Emery" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... > 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]