php - 无法使用变量从 Mysql 列中选择

Question

谁能帮助我，我快疯了，看不到我做错了什么！我有这个基本的 SELECT 查询：

$locationQuery = mysqli_query($conn, "SELECT * FROM uk_towns where county = 'Dyfed'");

这将返回 1,000 个结果……完美！

现在，如果我这样做：

$county = "Dyfed";
$locationQuery = mysqli_query($conn, "SELECT * FROM uk_towns where county = '$county'");

我什么都得不到？

@Dharman 它仍然不喜欢它。f 我使用变量，我没有得到结果。如果我手动输入它，它会返回我所期望的，但我知道该变量包含正确的数据。这就是我现在所拥有的：

$county = $userDetails['county'];
// $county = "Dyfed";
$town = $userDetails['town'];

$sql = "SELECT * FROM uk_towns WHERE county=? AND name=?";
$stmt = mysqli_stmt_init($conn);
mysqli_stmt_bind_param($stmt, "ss", $county, $town);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

while ($row = mysqli_fetch_assoc($result)) {
    echo $row['id'];
}

标签： phpmysqlselect