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]

Reply via email to