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.


Comments

Popular posts from this blog

mysql - FireDac error 314 - but DLLs are in program directory -

git - How to list all releases of public repository with GitHub API V3 -

c++ - Getting C2512 "no default constructor" for `ClassA` error on the first parentheses of constructor for `ClassB`? -