$results = $wpdb->get_results ( "SELECT name FROM testTable WHERE id=1" );

foreach ($results as $result ) {
   $name = $result->name;
}

$name = $result->name[0];