Hello!
What I was trying to find it out was the following...
www.gossamer-threads.com/scripts/forum/resources/Forum9/HTML/000034.html
Is this necessary?
$db->do ("DELETE FROM CategoryAlternates WHERE CategoryID = $id");
$db->do ("DELETE FROM CategoryRelations WHERE CategoryID = $id OR RelatedID = $id");
$db->do ("DELETE FROM CategoryHeiarchy WHERE CategoryID = $id AND Depth = 0");
$db->do ("DELETE FROM CategoryHeiarchy WHERE SubCategoryID = $id AND Depth > 0");
}Thanks
[This message has been edited by rajani (edited November 02, 1999).]
[This message has been edited by rajani (edited November 02, 1999).]
What I was trying to find it out was the following...
www.gossamer-threads.com/scripts/forum/resources/Forum9/HTML/000034.html
Is this necessary?
Code:
if ($db->{'db_table'} eq 'Category') { $db->do ("DELETE FROM CategoryAlternates WHERE CategoryID = $id");
$db->do ("DELETE FROM CategoryRelations WHERE CategoryID = $id OR RelatedID = $id");
$db->do ("DELETE FROM CategoryHeiarchy WHERE CategoryID = $id AND Depth = 0");
$db->do ("DELETE FROM CategoryHeiarchy WHERE SubCategoryID = $id AND Depth > 0");
}
[This message has been edited by rajani (edited November 02, 1999).]
[This message has been edited by rajani (edited November 02, 1999).]