I am trying to display the line_managers's nickname of a given user_id from my WP usermeta table.
The table looks like this:
user_id 2 has the line_manager value 1
'user_id' 1 has the nickname value MyNicknameString
Desired Result
User ID: 2
Line Manager ID: 1
Line Manager Nickname: MyNicknameString
PHP
User ID:
<?php echo bp_displayed_user_id(); ?>
<br>
Line Manager ID:
<?php
$line_manager = get_user_meta( bp_displayed_user_id() , 'line_manager' , true );
echo $line_manager;
?>
<br>
Line Manager Nickname:
<?php
$line_manager = get_user_meta( bp_displayed_user_id() , 'line_manager' , true );
$line_manager_nickname = get_user_meta( $line_manager , 'nickname' , true );
echo $line_manager_nickname;
?>
Current Result
User ID: 2
Line Manager ID: Array
Line Manager Nickname:
How do I correctly reference these key values?
EDIT: var_dump($line_manager) returns array data from the users table rather than the expected usermeta table. I would have expected it to print the usermeta.
EDIT 2: The following SQL works as I would expect the WP function to.
global $wpdb,$table_prefix;
$displayed_user = bp_displayed_user_id();
$line_manager_ID = $wpdb->get_var("SELECT meta_value FROM ".$table_prefix."usermeta WHERE user_id = ".$displayed_user." AND meta_key = 'line_manager' ");
echo $wpdb->get_var("SELECT meta_value FROM ".$table_prefix."usermeta WHERE user_id = ".$line_manager_ID." AND meta_key = 'nickname' ");

