WordPress database error: You have an error in your SQL syntax

Question

Below WordPress database error is coming:

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 1 for query SELECT * FROM wp_author_followers WHERE author_id = made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'),

Here is my code.

global $wpdb;
$results = $wpdb->get_results( "SELECT * FROM {$wpdb->prefix}author_followers WHERE author_id = $author_id", OBJECT );
$followcounter = count($results);
return $followcounter;

The braces are there to tell PHP that $wpdb->prefix is one expression, they are not the issue. My guess is that $author_id is empty. — janh
– janh, Commented Nov 23, 2017 at 7:23

Mr Shabir · Accepted Answer · 2017-11-23 13:04:46Z

1

Everything was correct, Just Author ID was not there, I have fixed this issue. Thanks for your attention and help.

answered Nov 23, 2017 at 13:04

Mr Shabir

1731 gold badge4 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AddWeb Solution Pvt Ltd · Accepted Answer · 2017-11-23 10:18:42Z

0

echo "SELECT * FROM {$wpdb->prefix}author_followers WHERE author_id = $author_id";

Try to echo $author_id before the SQL query, and check SQL statement after replacing $author_id with its value.

Thanks

answered Nov 23, 2017 at 10:18

AddWeb Solution Pvt Ltd

21.8k5 gold badges30 silver badges61 bronze badges

Collectives™ on Stack Overflow

WordPress database error: You have an error in your SQL syntax

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related