delete_rub.php
678 Bytes
<?php
require("./libs/setup.php");
$setup = new setup();
$objCatalogs = $setup->setupClass("Catalogs");
$rub_id = $objCatalogs->db->getOne("select id from catalogs_rubrics where translit=?",array('tur-ryukzaki'));
$res = $objCatalogs->db->getAll("select * from catalogs_products where rubric_id=?",array($rub_id),DB_FETCHMODE_ASSOC);
foreach($res as $row){
print $row['id']."<br>";
$objCatalogs->db->query("delete from catalogs_modifications where product_id=?",array($row['id']));
$objCatalogs->db->query("delete from catalogs_products_params where product_id=?",array($row['id']));
$objCatalogs->db->query("delete from catalogs_products where id=?",array($row['id']));
}
?>