[solved]How I can delete the supplier from product_supplier table on PS 1.7

[paulbeng]

Hi,
How I can delete the supplier from product_supplier table by id_product and id_supplier.
I am using deleteFromSupplier() method, but with this method disappears all suppliers by id_product selected.

 

[selectshop.at]

You want to empty a table direct on database ? You are coding a script ?

[paulbeng]

Yes, I'm coding a script.
Example:
I add a supplier with:
$prestaProduct->addSupplierReference($my_product_id = $my_supplier_id, 0, $my_supplier_reference, 0, 1);
(attach1)

Then, I want remove this one row.
(attach1)

With deleteFromSupplier() method disappears all suppliers by id_product selected.
(attach2)

What I can do? I want remove one row (one supplier).
(attach1)

Thanks

[paulbeng]

Whatever. Solved with DB query.