Pulling custom profile field data from MySQL dbase

[TheMusicMan]

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...?