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 ?

• mysql

Share Improve this question asked Mar 13, 2020 at 8:29 Kt HKt H 1522 silver badges66 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: 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;