Mysql SUM 之后的 PHP 条件

Question

>您好，所以我正在尝试获取 mysql 数据库中一列的总和是它的 0 预验证查询 1 其他查询 2

问题是它总是转到第一个条件而不是其他条件，即使来自 mysql phpmyadmin 的值显示 1 或 2，好像 if 条件有问题

 <?php
$servername = "localhost:3306";
$username = "****";
$password = "*****";
$dbname = "****";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
    $search = $_GET['search'];
    $sqlx = "SELECT SUM(`verified`) AS value_sum FROM Numbers WHERE `number` = ".$search." ";
    $resultx = $conn->query($sqlx);
    $sum = $row['value_sum'];
    if ($sum == 0)
    {
        $sql = "SELECT * FROM `Numbers` WHERE (`number` LIKE '%".$search."%' or `name` LIKE '%".$search."%') and `blocked` = 0 and `verified` = 0 GROUP BY `name` Limit 20";
        $result = $conn->query($sql);
    }
    else
    {
        $sql = "SELECT * FROM `Numbers` WHERE (`number` LIKE '%".$search."%' or `name` LIKE '%".$search."%') and `blocked` = 0 and `verified` = 1 GROUP BY `name` Limit 1";
        $result = $conn->query($sql);
    }

Answer 1

$sum = 0是一个赋值，因此$sum将变为 0。修复与==即$sum == 0的所有比较

正如评论中所建议的，请查看

3个不同的等号