problem driving me mad

[Bald Bouncer]

Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



can anyone fix this code so it will show the contents of profile field 14 next to the username....I think it needs to fetch the rray of $users and $field but Im not sure how its done :(

any help appreciated

[Chen]

You can join the user and userfield tables right in the first query:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


You also have this code twice in there, not sure it's supposed to be there (and if it is, use only one iif()):


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Bald Bouncer]

it will need to pull field14 from userfield not users i think....so how exactly do I use join to stick both the coloms in the same query mate?



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



I need to grab field14 from userfield in the above :dead:

[Chen]

Of course I forgot the JOIN line... duh.


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Bald Bouncer]

cheers for the help mate but its still not working :( dont happen to know were its going wrong do you mate?



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[Chen]

Ok replace "SELECT userid" with "SELECT user.userid".

[Bald Bouncer]

thanks a lot mate worked a charm!!
really appreciated!!

:p :bunny: