私信  •  关注

AkhilKrishnan

AkhilKrishnan 最近创建的主题
AkhilKrishnan 最近回复了
6 年前
回复了 AkhilKrishnan 创建的主题 » 尝试查找空列值时出现MySQL语法错误

像这样更改代码。

$query = $this->pdo->prepare('SELECT * FROM `' . $this->table . '` WHERE `wp_permalink` IS NOT NULL AND `wp_permalink` <> \'\' AND `id` != 2 AND `ga_page_views` != ' . $nogo . ' ORDER BY ga_page_views DESC LIMIT 6');

单引号用于指示SQL中字符串的开头和结尾。双引号一般不用于SQL,但可以从数据库到数据库有所不同。

也检查这个链接 difference between single and double quotes in SQL

How to use single quote inside an echo which is using single quote