Re: MySQL Query Question
First it would be nice to know what version of bp you are using. The latest trunk has lots of template functions and a new template class for the xprofile component.
Frankly the profile component is complicated in that it uses three tables to organize and get access to profile field data. Fields are accessed first by field group then field id then field value.
I don’t think that anyone is going to waste time on a detailed tutorial for RC1 code. Look at the following files and you’ll get an initial idea of how to access the profile fields.
/bp-xprofile/bp-xprofile-templatetags.php
/bp-xprofile/bp-xprofile-classes.php
With the template tags file being the most useful probably and the classes showing you how things are organized.