PHP MySQL WHERE子句列名错误 - PHP MySQL WHERE clause Column Name error

PHP MySQL WHERE clause Column Name error

本文关键字：错误子句 MySQL WHERE PHP | 更新日期: 2023-09-27

MySQL查询：

$sSix = "SELECT count(*) as count FROM `timers` WHERE `real_id` = {$row['real_id']}";
$rSix = mysql_query($sSix, $conn2);
echo mysql_error(); die;

结果："where子句"中的未知列"985_1445542200"

列名为real_id，但结果显示的是列"985_1445542200"。

你能告诉我错误的可能原因吗。

您的WHERE部分需要引号。像这样：

$sSix = "SELECT count(*) as count FROM `timers` WHERE `real_id` = '{$row['real_id']}'";

此外，请考虑使用较新的mysqli_函数或PDO函数，因为旧的mysql_函数将来将停止工作。

$sSix = "SELECT count(*) as count FROM `timers` WHERE `real_id` = "'. $row['real_id'].'";
$rSix = mysql_query($sSix, $conn2);
echo mysql_error(); die;