How to run mysql query in wordpress?

Question

This query works and returns the results I want in MySQL, but how do I get this to work in Wordpress?

SELECT * FROM `wp_usermeta` WHERE `meta_key` = 'points' AND `user_id` = '1'

I want to see all the "points" received from user 1. I need to be able to display this on posts and pages in Wordpress.

Answer 1

global $wpdb;    
$result = $wpdb->get_results( "SELECT * FROM wp_usermeta WHERE meta_key = 'points' AND user_id = '1'");
print_r($result);

Read this one .

Answer 2

Use the following code .....

$q="SELECT * FROM wp_usermeta WHERE meta_key = 'points' AND user_id = '1'";
$result = $wpdb->get_results($q);

As a result, it will return an array.