Reference additional registration fields

I’ve searched through the WordPress db and can’t find where the extra registration fields are stored. I created several custom fields for our registration form and I need to reference a few of those fields via query.

My client is an arts organization and I’ve set up a page for each artist with a slideshow and I want info about the artist pulled from the wp profile.

This is in my functions.php file:

$aUsersID = $wpdb->get_col(“SELECT $wpdb->users.ID FROM $wpdb->users WHERE display_name='” . $usertitle . “‘”);
foreach ($aUsersID as $iUserID) :
$user = get_userdata($iUserID);
echo ‘
‘ . $user->user_email;
echo ‘

‘ . $user->user_description . ‘

‘;

but the s2Member fields aren’t stored in the users table! where do I find those fields?

Okay, I see now where s2member stores the custom values in the users table, but the values are in an array. How do I break the array down, code-wise, in order to display the values? Basically, the custom fields I created are Title, Business Name, FAX (among others), but these are the ones I want referenced. So I don’t need to display EVERY custom field I created on the registration form, but a subset.

I got it now….

http://www.s2member.com/codex/stable/s2member/api_functions/package-functions/#src_doc_get_s2member_custom_fields%28%29

Cool. Glad you found it! Thanks for the update. :)