[RESOLVED] SELECT query doesnt return NULL values

[glima]

Hey guys, I know it might be really lame :S, I searched on google but it most of the returns I had where about pple not wnating que NULL values on the query:
So heres my problem: Im doing this query:

SELECT 
user_registered.userMoto, 
gender.gender,
eyecolors.eyeColor, 
haircolors.hairColor

FROM user_registered, gender, eyecolors, haircolors

WHERE 
user_registered.user_genderID = gender.genderID
AND eyecolors.eyeColorID = user_registered.user_eyeColorID  

AND user_registered.user_hairColorID = haircolors.hairColorID   

AND user_registered.user_userID = 57

and it works fine... when I have values in all fields... if one field doesnt have value... then I have no return at all... it says: Query returned 0 values.
I tried using CONCAT/_WS but still the Null fields doesnt come :S
Can sum1 help me? Plleeeease?

Thank you guys

[HalfaBee]

Because each field has to match the value.

NULL is not a redhead

[djjjozsi]

is it really needed to store these parameters in another tables?

if yes, it looks like this:

SELECT user_registered.user_userID, user_registered.userMoto, haircolors.hairColor, gender.gender, eyecolors.eyeColor
FROM ((user_registered LEFT JOIN eyecolors ON user_registered.user_eyeColorID = eyecolors.eyeColorID) LEFT JOIN gender ON user_registered.user_genderID = gender.genderID) LEFT JOIN haircolors ON user_registered.user_hairColorID = haircolors.hairColorID
WHERE (((user_registered.user_userID)=51));

left join means, i select evry values from user_registered table, and join into the connected values.

If in user registered table there is nothing, you might handle it, if you set default values.
if user does not select hair color, set 1 to the default, it is "Not set"

in this case, if no tnry for hair color, the list appear NULL.

good luck.

anyway, i have a girlffriend, who has blue and red eye, and her hair contains 3 colors🙂

f** Alien 🙂

[Roger_Ramjet]

You just need to use an OR

SELECT
user_registered.userMoto,
gender.gender,
eyecolors.eyeColor,
haircolors.hairColor

FROM user_registered, gender, eyecolors, haircolors

WHERE
(user_registered.user_genderID = gender.genderID OR user_registered.user_genderID IS NULL)
AND (eyecolors.eyeColorID = user_registered.user_eyeColorID  OR user_registered.user_eyeColorID  IS NULL)
AND (user_registered.user_hairColorID = haircolors.hairColorID  OR user_registered.user_hairColorID IS NULL)
AND user_registered.user_userID = 57 

[glima]

Thanks for the help guys! 😃 I used bth examples and worked fine 🙂 I chose to use the LEFT JOIN thought, dunno it seemed more easy for my twisted mind 😛