php - 为什么不满足标准参数时我的 SQL 会给出结果

Question

我有以下由 PHP 脚本执行的 SQL 查询。问题是即使$nameValue不满足参数，它仍然返回值。如何解决这个问题？我特别说：

WHERE ((driver_name = '$nameValue') AND
        status = 'FEDEX' or status = 'UPS')

只有当AND两者都满足时才应该返回，但它仍然显示所有状态是FEDEX或UPS

$sql =  "SELECT customer,
       sum( status = 'FEDEX' ) as PickedUpNUM,
       sum( status = 'UPS' ) as DeliveryNUM
        from Equipment
        WHERE ((driver_name = '$nameValue') AND
        status = 'FEDEX' or status = 'UPS')
        group by customer
        Order by DeliveryNUM DESC";

标签： phpsql

Answer 1

错误（）位置

$sql =  "SELECT customer,
          sum( status = 'FEDEX' ) as PickedUpNUM,
          sum( status = 'UPS' ) as DeliveryNUM
          from Equipment
          WHERE driver_name = '$nameValue' AND
          (status = 'FEDEX' or status = 'UPS')
        group by customer
        Order by DeliveryNUM DESC";