php - SQL Update Query - Attempt to put 0 in a field -
i'm using following update row in sql server database: "update bmraconfig set [pn operator] = '".$pnop."', [pn value] = '".$pnvalue."', [mel operator] = '".$melop."', [mel value] = '".$melvalue."', [ndz operator] = '".$ndzop."', [ndz value] = '".$ndzvalue."', [fuel type] = '".htmlentities($fueltype, ent_quotes)."' [pn operator] = '".$default["pnop"]."' "; however when 1 of variables equal 0 , example $melvalue == 0, field isn't updated. if value 51 example change, not when it's 0 .