admin管理员组文章数量:1394161
I have this error :
[You have an error in your SQL syntax; check the manual that corresponds
to your MariaDB server version for the right syntax to use near '' at line 4]
SELECT COUNT(*) FROM wp_postmeta AS a, wp_postmeta AS b
WHERE a.post_id = b.post_id AND (a.meta_key = 'customer_email'
AND a.meta_value LIKE '%[email protected]%') AND (b.meta_key = 'usage_count' AND b.meta_value = '0'
However, it works normally at PHPMYADMIN
I don't know what went wrong.
my code is
$rowcount = $wpdb->get_var("SELECT COUNT(*)
FROM $wpdb->postmeta AS a, $wpdb->postmeta AS b WHERE a.post_id = b.post_id AND (a.meta_key = 'customer_email'
AND a.meta_value LIKE '%[email protected]%') AND (b.meta_key = 'usage_count' AND b.meta_value = '0'");
echo $rowcount;
How to fix this ?
I have this error :
[You have an error in your SQL syntax; check the manual that corresponds
to your MariaDB server version for the right syntax to use near '' at line 4]
SELECT COUNT(*) FROM wp_postmeta AS a, wp_postmeta AS b
WHERE a.post_id = b.post_id AND (a.meta_key = 'customer_email'
AND a.meta_value LIKE '%[email protected]%') AND (b.meta_key = 'usage_count' AND b.meta_value = '0'
However, it works normally at PHPMYADMIN
I don't know what went wrong.
my code is
$rowcount = $wpdb->get_var("SELECT COUNT(*)
FROM $wpdb->postmeta AS a, $wpdb->postmeta AS b WHERE a.post_id = b.post_id AND (a.meta_key = 'customer_email'
AND a.meta_value LIKE '%[email protected]%') AND (b.meta_key = 'usage_count' AND b.meta_value = '0'");
echo $rowcount;
How to fix this ?
Share Improve this question asked Mar 13, 2020 at 8:29 Kt HKt H 152 silver badges6 bronze badges1 Answer
Reset to default 1) bracket missing in last condition. (i.e AND (b.meta_key = 'usage_count' AND b.meta_value = '0'"); )
$rowcount = $wpdb->get_var("SELECT COUNT(*)
FROM $wpdb->postmeta AS a, $wpdb->postmeta AS b WHERE a.post_id = b.post_id AND (a.meta_key = 'customer_email'
AND a.meta_value LIKE '%[email protected]%') AND (b.meta_key = 'usage_count' AND b.meta_value = '0')");
echo $rowcount;
本文标签： mysqlSQL syntax error Howeverit works normally at phpmyadmin
版权声明：本文标题：mysql - SQL syntax error. However, it works normally at phpmyadmin 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744672713a2618923.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。
发表评论