WordPress $wpdb->get_results() not returning value

Question

I'm in the process of looking at a WordPress plugin (never used WordPress before) and am running into an issue trying to execute a very basic SELECT statement against the database.

Ex:

$sql = "SELECT * FROM wp_posts";
$result = $wpdb->get_results( $sql );
var_dump($result);
echo($result);

This doesn't display anything even though my wp_posts table has a couple hundred rows. Can someone tell me what I'm missing? Thanks.

smcjones · Accepted Answer · 2016-11-16 21:29:23Z

1

This may or may not be the issue, but often, prefixes cause trouble and it is not recommended to hardcode tables in.

Secondly, can you output the value of $wpdb? If not, and this is most likely the problem, you don't have access to $wpdb in your scope.

Use global $wpdb if you are executing this within a function.

$sql = "SELECT * FROM $wpdb->posts";
$result = $wpdb->get_results( $sql );

answered Nov 16, 2016 at 21:29

smcjones

5,6411 gold badge25 silver badges43 bronze badges

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

1 Comment

jay Over a year ago

Looks like I didn't have access to $wpdb. I was able to access it via $GLOBALS['wpdb']->get_results. using global $wpdb fixed the issue.

Collectives™ on Stack Overflow

WordPress $wpdb->get_results() not returning value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related