Edit file File name : subcat-del.php Content :<?php session_start(); include("../include/config.php"); include("../include/functions.php"); validate_admin(); $arr =$_POST['ids']; //print_r($_REQUEST); $Submit =$_POST['what']; if(count($arr)>0){ $str_rest_refs=implode(",",$arr); if($Submit=='Delete') { $sql="delete from $tbl_gchildsubcat where subcat_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_childsubcategory where subcat_id in ($str_rest_refs)"; $obj->query($sql); $sql="delete from $tbl_subcategory where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) deleted successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Activate') { $sql="update $tbl_subcategory set status=1 where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) activated successfully'; $_SESSION['sess_msg']=$sess_msg; } elseif($Submit=='Deactivate') { $sql="update $tbl_subcategory set status=0 where id in ($str_rest_refs)"; $obj->query($sql); $sess_msg='Selected record(s) deactivated successfully'; $_SESSION['sess_msg']=$sess_msg; } } else{ $sess_msg="Please select check box"; $_SESSION['sess_msg']=$sess_msg; header("location: ".$_SERVER['HTTP_REFERER']); exit(); } header("location: subcat-list.php"); exit(); ?> Save