TED]>; <[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
u will undoubtable have more mysql
experience than me so please don't take this as some kind of points scoring
exercise / competition - I was just suggesting some additional features he
might want to consider at the same point.
Ollie
"Rick Emery" <[EMAIL PROTECTED]> wrote
ry 2002 16:13
To: '[EMAIL PROTECTED]'; Php-Db ML
Subject: RE: [PHP-DB] Inserting NULL values does not work
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
ML
Subject: RE: [PHP-DB] Inserting NULL values does not work
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: [PH
Like this for example:
http://www.phpbuilder.com/snippet/download.php?type=snippet&id=378
-Original Message-
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: 01 February 2002 16:01
To: Php-Db ML; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Inserting NULL values does not work
Why
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
ue.
>
> Or, you can:
>
> if ($park == 'false'){
> $park = NULL;
> }
> else{
> $park = "\"$park\"";
> };
>
> in you INSERT statement change: '$park',to $park,
>
> -----Original Message-----
> From: Andy [m
$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:
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 = "INS