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.
$sql = "SELECT * FROM wp_posts";
$result = $wpdb->get_results( $sql );
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.
global $wpdb if you are executing this within a function.
$sql = "SELECT * FROM $wpdb->posts"; $result = $wpdb->get_results( $sql );