Calling back buddypress data in member list

Hi all, thanks to the s2Member forum I’m working with a company in California!! I have built my custom searchable members list and am joining data from a buddy press table via my sql query – however when I try to call a field from that table within my foreach its just returning blank.

I’ve checked my query via phpmyadmin and the correct data is returned there, it just won’t write to the page (everything else from the user & usermeta tables comes back fine!).

My query is:
$users = $wpdb->get_results (“SELECT DISTINCT(U.ID) as `ID`
FROM ” . $wpdb->users . ” AS U
inner join ” . $wpdb->usermeta . ” as UM on U.ID = UM.user_id
left join wp_bp_activity as BP on U.ID = BP.user_id
WHERE BP.date_recorded = (
SELECT MAX(date_recorded)
FROM ast_bp_activity
WHERE user_id = BP.user_id
LIMIT 1
)
OR BP.date_recorded IS NULL
OR BP.date_recorded = ”
ORDER BY “.$_SESSION[‘sortby’].””);

and I’m using get_user_field(“date_recorded”, $user_id) to try and call the date_recorded data from bp_actvitiy, perhaps I should be calling it a different way??

Any ideas??

Thank you :D

Hi Zoe,

Congrats on your new job! :)

The problem you’re having is outside the the scope of s2Member’s support, but if the get_user_field() function is returning empty I suggest starting there: Does that function successfully return other user fields? If not, then is the user_id being passed properly? If other fields work, are you sure the date_recorded data is being stored in the database in the same way that other user fields are being stored?

I hope helps you narrow down the issue! :) If you’re still stuck, I suggest asking your question on the WordPress.org Support Forums or even Stack Overflow.