View difference between Paste ID: UnCPWiba and 5SMaw3ej

 <?php
 
 include 'database.php';
 // create a variable
 if($_SERVER["REQUEST_METHOD"]=="POST")
 {
 $username = mysql_real_escape_string($_POST['username']);
 $password = mysql_real_escape_string($_POST['password']);
 $idrole=$_POST['idrole'];
 $name=$_POST['name'];
 $icno=$_POST['icno'];
 $address=$_POST['address'];
 $postcode=$_POST['postcode'];
 $phone=$_POST['phone'];
 $email=$_POST['email'];
 $bool = true;
 //Execute the query
 
-$query2 = mysql_query("SELECT * FROM employee WHERE username= '$username'");
+$query2 = mysql_query("SELECT * FROM employee WHERE username = '$username'");
-if(mysql_num_rows($query2)>=1)
+if(mysql_num_rows($query2) == 0 )
    {
-    Print '<script>alert("Username has been taken !");</script>';
+	mysqli_query($connect, "INSERT INTO employee
-    Print '<script>window.location.assign("login.php");</script>';
+
 
 	if(mysqli_affected_rows($connect) > 0)
 	{
-   	  mysqli_query($connect, "INSERT INTO employee
+
 	Print '<script>window.location.assign("login.php");</script>';
    }else {
 	Print '<script>alert("Profile Not Added !");</script>';
 	echo mysqli_error ($connect);
   }
 
 
    }
  else
     {
    	 Print '<script>alert("Username has been taken !");</script>';
     Print '<script>window.location.assign("login.php");</script>';
 }
 
 mysqli_close($connect);
 }
 
 ?>