MySQL JOIN

[eluser]jedd[/eluser]
Try something like this instead:

Code:

SELECT
    * FROM users
LEFT JOIN
    userprofiles ON userprofiles.id = users.user_profile_id
WHERE
    users.id = $x

Two notes - first, use underscores between words within table and field names. Second, don't select * from tables unless you really need everything (you rarely do).