MySQL Forums
Forum List  »  Newbie

Join getting hard
Posted by: Aitor Cabrera
Date: November 11, 2009 08:23PM

Hello everybody,

I use mySQL as a hobbie so all I know about it is from the official manual. Today I did my first JOIN and it works but now I need to do another one more complicated and I don't know how. I'm doing a web based game:

table players
-------------
head | chest | legs | feet | rhand | lhand
------------------------------------------
1 | 3 | 1 | 2 | 4 | 1

table items
-----------
id | name
-----------
1 | nothing
2 | boots
3 | shirt
4 | dagger

In the players table I only save the id of the items but when I want to show them to the user I want to names to appear. Finally I did one SELECT for each column from "players" as I don't know how to put all together in one SELECT (if it's possible).

Anyone could give me a hand? I'm sure it can be done but I'm stuck right now.

Thank you!

Options: ReplyQuote


Subject
Written By
Posted
Join getting hard
November 11, 2009 08:23PM
November 11, 2009 09:45PM
November 12, 2009 06:52AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.