mysql_query SELECT语句中存在SQL语法错误 - SQL syntax error in mysql_query SELECT statement

SQL syntax error in mysql_query SELECT statement

我有一个mysql语法错误，告诉我："您的SQL语法有错误；请查看与mysql服务器版本对应的手册，以获取在第1行的'='upVote'附近使用的正确语法"

这是我的代码：

    $likedQuery = mysql_query("SELECT Liked FROM " . $cookie . "WHERE type = 'upVote'", $dbh2) or die (mysql_error());
$likedArray = mysql_fetch_array($likedQuery);
$allLikes = $likedArray['Liked'];

您应该在WHERE之前添加一个空格，更改：

$likedQuery = mysql_query("SELECT Liked FROM " . $cookie . "WHERE type = 'upVote'", $dbh2) or die (mysql_error());

至：

$likedQuery = mysql_query("SELECT Liked FROM " . $cookie . " WHERE type = 'upVote'", $dbh2) or die (mysql_error());

您的表名后面缺少一个空格

$likedQuery = mysql_query("SELECT `Liked` FROM `" . $cookie . "` WHERE `type` = 'upVote'", $dbh2) or die (mysql_error());
$likedArray = mysql_fetch_array($likedQuery);
$allLikes = $likedArray['Liked'];

使用反勾来转义字段和表标识符总是一个好主意

您可能需要$cookie和WHERE 之间的空间

$cookie . " " . WHERE