$wpdb-get_results

The $wpdb->get_results method is used to retrieve an array of results from a database query. It is part of the WordPress database class ($wpdb) and is typically used to interact with the WordPress database.

Here is an example of how to use $wpdb->get_results:

global $wpdb;

$results = $wpdb->get_results(
    "SELECT * FROM wp_posts WHERE post_status = 'publish' LIMIT 10"
);

foreach ($results as $result) {
    // Process each result
    echo $result->post_title;
}

In this example, we are retrieving the titles of the 10 most recent published posts from the WordPress database using an SQL query. The $results variable will hold an array of objects, with each object representing a post. We can then loop through the results and access the properties of each post object, such as post_title