Delete particular Manufacture

[speed2]

HI Guys, once of my manufacture is went bankrupt. Now how do I delete all of this product at once or how do I put all product as "SOLD OUT"

 

Please help

[boxtel]

HI Guys, once of my manufacture is went bankrupt. Now how do I delete all of this product  at once or how do I put all product  as "SOLD OUT"

 

Please help

<{POST_SNAPBACK}>

 

 

find the manufacturers id of the one you want out in manufactuters table

 

then update the products table

 

update products set products_status = 0 where manufacturers_id = the one

 

or set products_quantity = 0