user data

[sabret00the]

PHP Code:

$profile_info = $DB_site->query_first("SELECT (*)
                   FROM userfield
                 LEFT JOIN user ON (user.userid = userfield.userid)
                   $clause");
   
   $DB_site->fetch_array($profile_info) 


and then i can just call it in the templates as

$profile_info['field14']

right?
i think is the query (still not good with these left joins

and how do i get the age and website/homepage?