How to join 2 tables & display them correctly?
Posted
by
steven
on Stack Overflow
See other posts from Stack Overflow
or by steven
Published on 2010-06-18T21:01:35Z
Indexed on
2011/11/20
9:52 UTC
Read the original article
Hit count: 198
http://img293.imageshack.us/img293/857/tablez.jpg Here is a picture of the 2 tables.
The mybb_users table is the table that has the users that signed up for the forum.
The mybb_userfields is the table that contain custom profile field data that they are able to customize & change in their profile.
Now, all I want to do is display all users in rows with the custom profile field data that they provided in their profile(which is in the mybb_userfields table)
How can I display these fields correctly together?
For instance, p0gz is a male,lives in AZ,he owns a 360,does not know his bandwidth & Flip Side Phoenix is his team. How can it just be like "p0gz-male-az-360-dont know-flipside phoenix" in a row~???
© Stack Overflow or respective owner