Returning Rows

[The Little Guy]

OK... Here is the thing... All users are in the users table, so every user will have a row.

Not all users have images uploaded, so in the user_images table, they may not have rows.

I want to select the user from the table whether or not he/she has any default images.

If the user_images table has no rows for $id, then i should still get results if there is a row for $id in the users table.

How do I do this?

 

Current SQL:

SELECT * FROM user_images,users WHERE 
user_images.ownerID = '$id'
AND
users.id = user_images.ownerID
AND
(`default` = '1' OR `default` IS NULL)
LIMIT 1

[teng84]

OK... Here is the thing... All users are in the users table, so every user will have a row.

Not all users have images uploaded, so in the user_images table, they may not have rows.

I want to select the user from the table whether or not he/she has any default images.

If the user_images table has no rows for $id, then i should still get results if there is a row for $id in the users table.

How do I do this?

 

Current SQL:

SELECT * FROM user_images,users WHERE 
user_images.ownerID = '$id'
AND
users.id = user_images.ownerID
AND
(`default` = '1' OR `default` IS NULL)
LIMIT 1

 

 

why do you have to include the  and condition if you dont want that to haapen or you want the value that you are limiting

[The Little Guy]

huh?

[teng84]

explain a bit more

[sasa]

SELECT users.*, user_images.* FROM users LEFT JOIN user_images ON users.id = user_images.ownerID WHERE users.id = '$id'

something like this

[The Little Guy]

I think that is it... I need to do more testing, but it works for the moment. thanks!