MySQL JOIN

[eluser]tekhneek[/eluser]

Code:

SELECT * FROM users AS u, users_profiles AS up WHERE
u.uid = up.fk_uid AND
u.uid = {$row->id}

Something like that maybe? That's essentially the same as

Code:

SELECT * FROM users JOIN users_profiles ON users.uid = users_profiles.fk_uid WHERE users.uid = {$row->uid}

Or that