The original error message is because your query didn’t work, and it returned false instead of returning a set of results. I can’t say why that would be, because I don’t know your database table layout. Without that information, I don’t see how anyone can help to get the query to work. You said earlier that you’ve “uploaded the database photo” - where did you upload it?
Normally people come to forums to learn how to solve their problems, it’s unusual that people will just fix your code for you, more likely that someone will help to explain how you can fix it.
Thanks for the correct code you sent me via email. I know you did this to help me because my English is so poor. Your code words and solves my problem so I give you credit for the solution. I leave it to you to upload your solution if you wish.
So this means I will probably pay for Premium again soon.
There was only some slight modifications to what you had, mostly separating the “authorized” from the successful log in. I didn’t want to change too much. There is still many things that can be improved upon.
if(empty($num)) {
$login_err = "Invalid email or password.";
}elseif(!empty($num)) {
if($num['authorized'] == "0"){
echo "<script>alert('Sorry, you do not have access at this time.');</script>";
header("refresh: 0; URL=not-authorized.php");
}else{
//If the code gets here, You know that authorized was 1, and there is data, so their email and password matched.
$_SESSION['id']=$num['id'];
$_SESSION['name']=$num['fname'];
header("location: home.php");
exit;
}
}