On Jun 15, 2007, at 3:51 AM, andy@spiders-lair.com wrote:
I want users to provide more profile, and module profile can solve this issue. But it's not convenient to query the data, which user provides. Because the data has been saved in 'profile_fields' and 'profile_values', two tables separately.
Think you're missing the point of "API". Use the user_load() function which loads a user, profile and all for your convience. If you want to see the structure returned (and where the profile fileds are) install the devel module which can display this for you.
As an alternative, you could install (shameless plug) site_user_list.module. Although the primary purpose of this module is not what you're after, it has a nice side effect of being able to create a database view which will look like a proper table of all the profile data. There is some setup you would need to do (to tell it which profile columns you want in the table), but afterwards you would be able to just select data from it. There are still some cases where it might not be useful (especially if you're using MySQL < 4.1; less so if you're < 5.0) because of issues either with what the database supports, or keeping the data up- to-date; but it might help... HTH, Ricky The information transmitted in this electronic communication is intended only for the person or entity to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this information in error, please contact the Compliance HelpLine at 800-856-1983 and properly dispose of this information.