At 01:22 PM 5/10/2002, Paul DuBois wrote:
>At 13:11 -0500 5/10/02, Steve Buehler wrote:
>>I have found that I can NOT do this:
>>$null = "NULL" or even $null = NULL than put that into a statement like this:
>>UPDATE games SET game_id = '$null';
>>can't do it like this either
>>UPDATE games SET game_id = $null;
>>I have to do it like this:
>>UPDATE games SET game_id = NULL;
>>NO QUOTES of any kind. Somebody else might have a way around this. In
>>that case, I would like to hear it too. That would let me get around the
>>following:
>
>None of those will work, because you test for NULL using
>IS NULL, not = NULL.
The above ones aren't testing for NULL, they are trying to assign NULL to a
$var. The below ones aren't either. The below code is testing for
"". Might be the same thing, but it was the only way I could get it to
work for me. I didn't try:
if($loc_id IS NULL)
This code is in PHP.
>>$searchStmt = "UPDATE games SET
>>date = '$date',
>>time = '$time',";
>>if($loc_id == ""){$searchStmt .= "loc_id = NULL,";}else{$searchStmt .=
>>"loc_id = '$loc_id',";}
>>if($hteam_pt == ""){$searchStmt .= "hteam_pt = NULL,";}else{$searchStmt
>>.= "hteam_pt = '$hteam_pt',";}
>>if($vteam_pt == ""){$searchStmt .= "vteam_pt = NULL,";}else{$searchStmt
>>.= "vteam_pt = '$vteam_pt',";}
>>if($sea_id == ""){$searchStmt .= "sea_id = NULL,";}else{$searchStmt .=
>>"sea_id = '$sea_id',";}
>>if($hteam == ""){$searchStmt .= "hteam = NULL,";}else{$searchStmt .=
>>"hteam = '$hteam',";}
>>if($vteam == ""){$searchStmt .= "vteam = NULL,";}else{$searchStmt .=
>>"vteam = '$vteam',";}
>>if($hteam_forfeit == ""){$searchStmt .= "hteam_forfeit =
>>NULL,";}else{$searchStmt .= "hteam_forfeit = '1',";}
>>if($vteam_forfeit == ""){$searchStmt .= "vteam_forfeit =
>>NULL,";}else{$searchStmt .= "vteam_forfeit = '1',";}
>>if($official_1 == ""){$searchStmt .= "official_1 =
>>NULL,";}else{$searchStmt .= "official_1 = '$official_1',";}
>>if($official_2 == ""){$searchStmt .= "official_2 =
>>NULL,";}else{$searchStmt .= "official_2 = '$official_2',";}
>>if($official_3 == ""){$searchStmt .= "official_3 =
>>NULL,";}else{$searchStmt .= "official_3 = '$official_3',";}
>>if($official_4 == ""){$searchStmt .= "official_4 =
>>NULL,";}else{$searchStmt .= "official_4 = '$official_4',";}
>>if($official_5 == ""){$searchStmt .= "official_5 = NULL
>>";}else{$searchStmt .= "official_5 = '$official_5' ";}
>>$searchStmt .= "where game_id = '$game_id'" ;
>>
>>The previous is in a PHP script calling a MySQL DB.
>>
>>Steve
>>
>>
>>At 12:22 PM 5/10/2002, raphael k wrote:
>>>I created a table with a field define as NULL, however when I insert
>>>values NULL , Mysql puts 0 instead of nothing ,
>>>
>>>I don't understand why I have this trouble ,
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
