[dangmnx]

i have two tables under my account called test one is called members, the other is called matches 2

here is the code for matches2

$result = mysql_query("SELECT id, date, code2, winner, pointsg, loser, pointsl, replay FROM matches2 ORDER BY id DESC");

i would like to add a table from members in matches 2, is that possible?

here the code for members

$result = mysql_query("SELECT code, setname, rating1, wins, loses FROM members ORDER BY rating1 DESC LIMIT 5 ");

i want to add the id "rating1" inside matches2. how can i write that?

This post has been edited by dangmnx: 21 April 2009 - 08:16 PM

[maffelu]

You want to look at foreign keys I think:

morkalork.com/SubArticles/gener...n-key-works.htm
java2s.com/Tutorial/MySQL/0080_...ForeignKeys.htm

This post has been edited by maffelu: 21 April 2009 - 11:05 PM

[pemcconnell]

I covered this in a post yesterday if you want to take a look:

http://www.dreaminco...topic100676.htm

You need to use JOINs to connect multiple database tables

This post has been edited by pemcconnell: 22 April 2009 - 12:59 AM