Left Join in query ?

[Imran]

OK. I used following query;

PHP Code:

$query = $db->query(" SELECT u.uid, u.username, u.usergroup, u.email, regip, uid=".intval($user_info['uid'])." FROM ".TABLE_PREFIX."users u LEFT JOIN ".TABLE_PREFIX."userfields f ON u.uid=f.ufid ");

---

It gets data from users table but userfields / custmom profile field's value remains empty...

What's going wrong with me Yumi ?