<?php
include "config/config.php";

$delete=$_GET["key"];
$r=mysqli_query($con,"select * from division where `Div_Id` = '$delete'");
$row=mysqli_fetch_array($r);
$num8=mysqli_query($con,"SELECT * FROM `stud_basic` where `stud_basic`.`Division` = '$row[Name]'");

$num9=mysqli_num_rows($num8);

							  if($num9 >= 1)
							  {?>
								  <script>
								  alert("You Cant Edit This Because Students are Exists In the List ");
								  document.location="division.php";
								  </script>
							  <?php
							  }
							  else
							  {
							  
mysqli_query($con,"DELETE FROM `division` WHERE `division`.`Div_Id` = '$delete' ");
							  }


?>
<script>
	document.location="division.php";

	</script>