// ******************************************************************* // admin/delete_category.php // ******************************************************************* include("../include/config.php"); include("../include/functions.php"); include("../include/lang/$language.php"); include("../include/session.php"); session_start(); ?>
|
if(isset($ID)){
$get_cat = sql_query("
select
*
from
$tb_categories
where
ID='$ID'
");
$get_row = sql_fetch_array($get_cat);
$check_for_child = sql_query("
select
*
from
$tb_categories
where
PID='$get_row[ID]'
");
$count_parent_row = sql_num_rows($check_for_child);
if($count_parent_row > 0){
echo " Cannot delete " . $get_row[Category]; echo ", you must delete it's subcategories first. "; echo "Click here to continue "; } else { if( $delete = sql_query(" delete from $tb_categories where ID='$ID' ") ){ echo " Category " . $get_row[Category]; echo " has been deleted. "; echo "Click here to continue "; } else { echo " Could not delete " . $get_row[Category]; echo ", it doesn't exist. "; echo "Click here to continue "; } } } ?> |