[anhhuan]

when i do select to pull certain data out of the member table how can i also pull the related information from other talble as well

or should i make one big table??

PHP Code:

CREATE TABLE member (

memberID INT NOT NULL AUTO_INCREMENT,

lastName VARCHAR (50),

firstName VARCHAR (50),

address VARCHAR (255),

phone CHAR (15),

PRIMARY KEY (memberID));



CREATE TABLE primary (

primaryID INT NOT NULL AUTO_INCREMENT,

lastName VARCHAR (50),

firstName VARCHAR (50),

address VARCHAR (255),

phone CHAR (15),

PRIMARY KEY (primaryID ));



CREATE TABLE second (

secondID INT NOT NULL AUTO_INCREMENT,

lastName VARCHAR (50),

firstName VARCHAR (50),

address VARCHAR (255),

phone CHAR (15),

PRIMARY KEY (secondID)); 

[nekeno12]

SELECT * FROM member, primary, second

[nekeno12]

I noticed your columns look the same, so you may just want to make 3 separate queries.

[anhhuan]

it just sample there will be alittle bit differernt
so basicly i just select from all 3 ??
i just wonder like can i just do

PHP Code:

SELECT memberID FROM member 

and it will pull all the informations of this member even the data is in diffrent table and display this member and all of his informations only

[nekeno12]

No, you'll want to change that to:

$query = SELECT * FROM member WHERE memberID = $memberid

This way all your results are for that member only.

[darkfreak]

You may also want to get familiar with the JOIN -syntax. I'm not going to try to explain it here exactly but there's a good short tutorial at w3schools.com. One thing you should take a note of is the if you JOIN multiple tables in one, you cannot have many columns with the same name - instead you will have to rename them something like:

SELECT table1.col1 AS t1c1, table2.col2 AS t2c1, ... FROM table1 LEFT JOIN table2 WHERE table1.foreignkey=table2.key

where, for example, both table1.col1 and table2.col2 can be something like customers.LastName and salespeople.LastName (like in a case if you would like to get the names of customers and salespeople returned in the same result table).

Check here for better explanation:

http://www.w3schools.com/sql/sql_join.asp

[anhhuan]

thanks guys