get a single row from a table in the db

versatile way to get single piece of info related to something you already have

$user = $wpdb->get_row($wpdb->prepare("SELECT * FROM $wpdb->users WHERE user_activation_key = %s AND user_login = %s", $key, $login));
    if ( !empty( $user ) ){
			$username = $user->name;
	}