How to retrive fileds from #_comprofiler ?

Hello , I tried all below methods still I'm not able to retrieve the filed value from #_comprofiler .

Kindly I request to suggest me in this.

First method.

function funcasd($myId){
global $_CB_database;

$query="SELECT cb_customefldone"
. "\n FROM jos_comprofiler"
. "\n WHERE userid=" . $myId ;

$_CB_database->setQuery($query);
$result = $_CB_database->loadResult();
return ($result == NULL) ? 'Not success' : $result;
}

after this I called the function but no result.

Second method

$queryusrcat="SELECT cb_customefldone"
. "\n FROM jos_comprofiler"
. "\n WHERE userid=" . $myId ;

mysql_query($queryusrcat);
$usrcat = mysql_query($queryusrcat);


Thanks.

If you're doing this outside of the cb framework you need to add the cb api first, then you would do something like:
Krileon has a link to a good tutorial in his forum signature that goes into more detail on it.

I have a similar problem:

$user = &JFactory::getUser(); $userid = $user->id; $db = &JFactory::getDBO(); $db->setQuery("SELECT `cb_profiletype` FROM #__comprofiler WHERE id =" . $user->id); $profiletype = $db->loadResult();
$db->setQuery("SELECT `name` FROM #__comprofiler WHERE id =" . $user->id); $name= $db->loadResult();

I'm using the above code.

The problem is that $profiletype works, but $name is blank.

I checked the underlying profile and the name field definately has the name in it.

Any ideas?