[RESOLVED] How to create alias (fields)?

[web_designer_iq]

Hi,
I have 2 MySQL table with similar fields.
for example:

table1 (What's your hair color):
1
2
3
table2 (Wha'ts your wife hair color):
1
2
3

table3 (Hair color table):
1 -> Red
2 -> Blond
3 -> Black

see! i can't get all fields because man and his wife under define colors.
i want to get all fields by one query!
for example (it's worng example):

SELECT * FROM man AS m, wife AS w, m.hair_color, w,hair_color
WHERE user_id = 12

thank you

[tsinka]

You need to do something like e.g.

SELECT *, m.hair_color AS mhaircolor, w.hair_color AS whaircolor FROM man AS m, wife AS w WHERE ....

Use e.g. $row = mysql_fetch_assoc($queryresult) and fetch the values with $row['mhaircolor'] and $row['whaircolor']

Thomas

[web_designer_iq]

Thank you my dear 🙂
that's great and very easy 🙂