Membership Database Help

[Anon]

I have a membership database set up to track player names in a game. The way I have the mySQL database setup is as follows:

Member Table
- autonum
- member name
- joined date
- rank (recruit, member, admin)
- active (Y or N)

Character Table
- autonum
- member name (MUST be in member table already)
- character name (one member may have 5 characters)
- character type
- character level
- character class

---

My question is this. If I want to query this information to show the MEMBER - his JOIN DATE - his CHARACTERS, and their LEVELS...

how would that query look? No clue here...new to this! (am an old MS Access junkie...learning SQL).

Thanks in advance.

[Anon]

$query = mysql_query("SELECT * FROM tablename");
$rows = mysql_num_rows($query);

while ($i < $rows) {
$row[$i] = mysql_result($query, $i);
$i++;
}

[Anon]

LOL - I am ignorant! I follow the idea of what this query does...

$query = mysql_query("SELECT * FROM tablename");
$rows = mysql_num_rows($query);

while ($i < $rows) {
$row[$i] = mysql_result($query, $i);
$i++;
}

---

Assuming my table names are MEMBERS and CHARACTERS - and the field that relates in each of them is MEMBERNAME - how do I plug it into the above to display information in both tables?

Sorry...very new to this...figuring it out as I go!

[Anon]

OK, so its ages since you posted this message, but as a newbie myself I thought it would be a good exercise! Would this work:

SELECT m_t.member_name, m_t.joined_date, c_t.member_name, c_t.character_type, c_t.character_level FROM m_t, c_t WHERE m_t.member_name=c_t.member_name

(note: m_t=member table, c_t=character table)

This (I think) should produce a table as you wanted.

Paul