How to assign results to variables?

Best luck while you learn.

$fivesdrafts = $wpdb->get_results( 
    "
    SELECT ID, post_title 
    FROM $wpdb->posts
    WHERE post_status="draft" 
        AND post_author = 5
    "
);

foreach ( $fivesdrafts as $fivesdraft ) 
{
    echo $fivesdraft->post_title;
}

This example has been sponsored by WordPress codex.


In your case

$wpdb->get_results(

Should become like:

$variable_to_print = $wpdb->get_results(