Jump to content

Edit History

Sandro Cianfarani

Sandro Cianfarani

Hi uzishabab,

have you an example in php code?

This is the query:

UPDATE ps_customer INNER JOIN ps_address ON ps_address.id_customer = ps_customer.id_customer
SET ps_customer.id_default_group=6 WHERE ps_address.vat_number <>'' AND ps_address.id_customer=4611

INSERT INTO ps_customer_group (4611,6)

Thanks

Sandro Cianfarani

Sandro Cianfarani

Hi uzishabab,

have you an example in php code?

This is the query:

UPDATE ps_customer INNER JOIN ps_address ON ps_address.id_customer = ps_customerCOPIA.id_customer
SET ps_customerCOPIA.id_default_group=6 WHERE ps_address.vat_number <>'' AND ps_address.id_customer=4611

INSERT INTO ps_customer_group (4611,6)

Thanks

×
×
  • Create New...