检查电子邮件是否已激活但不起作用 - Check if email is already activated not working

Check if email is already activated not working

我刚刚创建了一个脚本，用于检查用户是否已经激活了他的帐户。如果是，它应该说"该帐户已经被激活"，如果不是，则激活该帐户。问题是它总是说"激活成功"。有人能帮我吗？

<?php
session_start();
include_once 'dbconnect.php';
$dbconnect = mysqli_connect('server', 'user', 'password', 'database');
if (isset($_GET['email'])) {
    $email = $_GET['email'];
}
if (isset($_GET['status']) && (strlen($_GET['status']) == 32)) {
    $status = $_GET['status'];
}
if (isset($email) && isset($status)) {
    $sql = "SELECT status FROM users WHERE email='$email'";
    $result = mysql_query($sql);
    if ($result == 'active') {
        echo" <div style='position:absolute;left:29.5%;top:10%;width:41%;' class='alert alert-danger'>
             <a href='#' class='close' data-dismiss='alert' aria-label='close'>&times;</a>
             <strong>Chyba!</strong> &#218;&#269;et je ji&#158; aktivov&#225;n!
             </div>";
    } else {
        $query_activate_account = "UPDATE users SET status='active' WHERE(email ='$email' AND status='$status')";
        $result_activate_account = mysqli_query($dbconnect, $query_activate_account);
        echo" <div style='position:absolute;left:29.5%;top:10%;width:41%;' class='alert alert-success'>
             <a href='#' class='close' data-dismiss='alert' aria-label='close'>&times;</a>
             <strong>ĂšspÄ›ch!</strong> Aktivace probÄ›hla ĂşspÄ›ĹˇnÄ›! <a href='signin.php'>PĹ™ihlĂˇĹˇenĂ</a>
             </div>";
    }
}
?>

更新

 $sql = "SELECT status FROM users WHERE email='$email'";
    $result = mysql_query($sql);
to 
 $sql = "SELECT status FROM users WHERE email='$email'";
    $result = mysql_query($sql);
while($row = mysql_fetch_assoc($result )){
  $status = $row['status'];
}

并更换

if ($result == 'active') {

带有

if ($status== 'active') {