user data

[sabret00the]

sorry for this, i've lost all confidence and knowledge in matters of coding for the night, so again i'm sorry for bothering you all.

but how would i select the data from the user table and userfield table as an array so i could call some of the data i.e.

Age
Location
Occupation
then some of the custom user profile fields

this is for a page powered by vBulletin but not a standard file (i.e. my own one).

[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?

[sabret00the]

*bump*

[AN-net]

the query looks good for profile fields and to get homepage etc. you have to look in the user table(im using vb3)

[sabret00the]

i can't even get the query to work in php my admin

[Xenon]

why not just use the fetch_userinfo() function of vb3?

[sabret00the]

cos i didn't know it existed

how would i go about using the fetch_userinfo() based on a static userid

i.e. fetch_userinfo(userid = $juserid, field24)?

[Xenon]

hmm, what i did was something like this when i need it:

PHP Code:

$userid = xx;
$userinfo = fetch_userinfo($userid); 


[sabret00the]

sorry to be a pain, just trying to grasp this still

ok so i would apply the above to the file (in php format)

but how would i call the information in the templates?

$userinfo[fieldXX]?

[Xenon]

exactly like that.

the userinfo looks like the bbuserinfo array