Left Join in query ?

[ZiNgA BuRgA]

MyBB's "simple_select" isn't really designed for that thing.  You'll need to write the full query yourself.

Joins are probably something difficult to conceptualise at first, but the idea is to link a field of one table to a field of another.

SQL Code

SELECT u.username, u.email, u.regip FROM mybb_users u LEFT JOIN mybb_userfields f ON u.uid=f.ufid

---