It won't fail if it is enclosed in double-quotes. That is:
INSERT INTO mytable (name) VALUES("O'leary")
is OK.
-----Original Message-----
From: Oliver Cronk [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 01, 2002 10:41 AM
To: Rick Emery; [EMAIL PROTECTED]; Php-Db ML
Subject: RE: [PHP-DB] Inserting NULL values does not work
I know its not failing on YOUR example but if there is a single quote in the
data eg someones name is O'leary then the SQL will fail surely?
Ollie
-----Original Message-----
From: Rick Emery [mailto:[EMAIL PROTECTED]]
Sent: 01 February 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 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]
