我想在我编写的以下代码中更新 a 过滤器。我很困惑如何放。
代码是:
$query = "SELECT P.`Building_info` as `name`,P.`Area` as `area`,
avg(
CASE
WHEN P.`Bedroom`='4'
THEN P.`$price`
ELSE NULL
END
) AS 'Beds_4',
avg(
CASE
WHEN P.`Bedroom`='5'
THEN P.`$price`
ELSE NULL
END
) AS 'Beds_5'
FROM All_Rent P
WHERE P.Building_info<>''
AND Sale_Rent='$accom'
AND converted_date > '$min_date'
GROUP BY P.`Building_info`";
我想添加一个过滤器,Area = "Euston Road"
即仅选择名称为"尤斯顿路"
谁能帮忙?
假设您使用的值为"Euston Road"的名为 $area 的变量,只需将查询更新为:
$query = "SELECT P.`Building_info` as `name`,P.`Area` as `area`,
avg(
CASE
WHEN P.`Bedroom`='4'
THEN P.`$price`
ELSE NULL
END
) AS 'Beds_4',
avg(
CASE
WHEN P.`Bedroom`='5'
THEN P.`$price`
ELSE NULL
END
) AS 'Beds_5'
FROM All_Rent P
WHERE P.Building_info<>''
AND Sale_Rent='$accom'
AND converted_date > '$min_date'
AND P.`Area` = '$area'
GROUP BY P.`Building_info`";