PHP SQL UPDATE TABEL WITH NULL VALUE

[Marius05]

Hi!

 

How ken update column in table with NULL value?

Db::getInstance()->update('product_attribute_shop', array('default_on' => NULL,), '`id_product` = '.(int)$x.' AND `id_product_attribute` = '.(int)$y);

set 0 value.

 

Thank you

[modprestashop]

With update() function you can't achieve that. Do this instead.

Db::getInstance()->execute('UPDATE `ps_product_attribute_shop` SET `default_on` = NULL WHERE `id_product` = '.(int)$x.' AND `id_product_attribute` = '.(int)$y);

You need to do this because update function wrap your NULL with single quote and it becomes string then.

[Marius05]

Thank you!

 

Problem solved.