TheMusicMan
03-24-2007, 06:46 AM
Hi All
Can someone help me with this one please. I am writing some code that needs to grab data from one or more Custom Profile Fields. I need to obtain this profile information from the MySQL database (obviously) and am wondering how I get it.
I see there is a profilefields table that contains details of the actual profile fields (including custom ones), but which table do I query to get at the custom profile data for a member?
Specifically, I want to be able to pull and retrieve data, then sort this data, then present this data across all (or a selection of) my member records.
How do I do this please? I know it's via a
SELECT * from table_name WHERE conditions_here_ ORDER BY etc
But what table do I query to get at the custom profile data items for a member...?
Can someone help me with this one please. I am writing some code that needs to grab data from one or more Custom Profile Fields. I need to obtain this profile information from the MySQL database (obviously) and am wondering how I get it.
I see there is a profilefields table that contains details of the actual profile fields (including custom ones), but which table do I query to get at the custom profile data for a member?
Specifically, I want to be able to pull and retrieve data, then sort this data, then present this data across all (or a selection of) my member records.
How do I do this please? I know it's via a
SELECT * from table_name WHERE conditions_here_ ORDER BY etc
But what table do I query to get at the custom profile data items for a member...?