Pulling custom profile field data from MySQL dbase

[MarkPW]

query_first() executes a data-reading SQL query, returning an array of the data from the first row from the result set.

To access your custom data, you would do:

PHP Code:

$userdata = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "userfield WHERE userid=1");

echo '<pre>';
print_r($userdata);
echo '</pre>';

echo  $userdata['field1']; //and so on