ID: 20506 User updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Open Bug Type: MySQL related Operating System: Windows98 PHP Version: 4.2.1 New Comment:
Using $specialprice="Null"; or $specialprice=Null; gives the same result Previous Comments: ------------------------------------------------------------------------ [2002-11-19 15:57:59] [EMAIL PROTECTED] In short: $specialprice="Null"; $query = "UPDATE mytable SET mytable.specialprice = '".$specialprice."' WHERE ......"; submitted a "0"(zero) into mysql. and: $specialprice="mytable.specialprice =Null"; $query = "UPDATE mytable SET '".$specialprice."' WHERE ......"; submitted Null, like it should. I couldnt account why the first version would submit "0" the mysql field has the following properties: type:float, length=11, decimals=2, allow null:true, unsigned: false, zerofill: false, default value:empty ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=20506&edit=1
