我的If语句与mysql数据不比较？

Question

Halo, I got a If statement here but is not working. The system just pass me to the last page which I set it. And that is not what I want. What I want here is when the user login, the system automatic check the user belong to which department and send them to the correct page.

$departmentsql="SELECT department FROM staff_table";
$departmentsqlresult=mysql_query($departmentsql);
$departmentcount=mysql_num_rows($departmentsqlresult);
if($departmentcount == "A"){
header("location:departmentA.php");
}
else if($departmentcount == "B"){
header("location:departmentB.php");
}
else if ($departmentcount == "C"){
header("location:departmentC.php")
}

The system just send me to the departmentC.php every time, no matter which user I login. And that is not what I want. Can anyone tell me whats wrong with my code? Appreciate for your answer. Thanks

Answer 1

You have 2 errors :

if($departmentcount == "A"){
  header("location:departmentA.php");
}

>> $departmentcount will contain a numric value

PHP doesn't implictyly typecast, so when you compare 2 values, it treats both of them of same type.

On comparison, since you are comparing $departmentcount with a char, it'll expect $departmentcount to contain char value too, which is not the case...so condition becomes false for all of your if and elseif, hence no output

Compare it like

if($departmentcount == 10) //compare with number

>> when you'll compare successfully, header wont redirect, because your syntax for header is also incorrect

Correct it this way :

header("Location: departmentA.php");
  /* you need a ^^ space here */