DELETE FROM produse WHERE id_categorie = '$id';
DELETE FROM categorii WHERE id_categorie = '$id';

the $id is the same.
i am building a product catalog and "produse" is the products and "categorii" is the cathegories ... when i delete one cathegorie it must delete all products belonging to it.

how do i combine the two queries in a single one? i am pretty tired and can't think clear now ... but i need it done asap

i'm not interrested in the php solution. need sql solution.

anyone?

Originally Posted by OmuCuSucu

DELETE FROM produse WHERE id_categorie = '$id';
DELETE FROM categorii WHERE id_categorie = '$id';

Try this:

DELETE FROM produse, categorii WHERE id_categorie = '$id';

that doesn't work compmodder26... tried that before posting.

DELETE categorii, produse FROM categorii, produse WHERE categorii.id_categorie = '$id'AND produse.id_categorie = '$id'

this does. found my solution. it was the specifications before FROM and adding table.column in the WHERE clause that i did wrong.

thank for the quick reply anyway i don't have much time for this project and everything matters.

thread can be closed

i guess u use Join statement

yes, there is a comma between the tables. that is a join.