php mysql join query

Question

I need to pull data from 2 tables in my database. The data I pull from table 2 depends on the result of table 1.

I'm not amazing at all these JOINS and things, so if someone could just explain what kind of a JOIN i'd need here, and how it would look, i'd be grateful:

$sql_result = mysql_query("SELECT * FROM accounts WHERE id='$val'", $db); 
$rs = mysql_fetch_array($sql_result); $name = $rs[name];

$sql_result2 = mysql_query("SELECT * FROM players WHERE name='$name'", $db); 
$rs2 = mysql_fetch_array($sql_result2);

Whetstone · Accepted Answer · 2011-10-24 14:24:35Z

1

$sql="SELECT * FROM accounts JOIN players ON accounts.accounts_link_to_player_id_here=players.id WHERE accounts.id='$val'";

answered Oct 24, 2011 at 14:24

Whetstone

1,2099 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Whetstone Over a year ago

Could you mark the question answered for future Googlers? Thanks!

Rudi Visser · Accepted Answer · 2011-10-24 14:29:52Z

1

You can do something like this, depending on the structure of the table(s):

SELECT * FROM `accounts` INNER JOIN `players` USING (`name`) WHERE `accounts`.`id` = 'value';

answered Oct 24, 2011 at 14:29

Rudi Visser

22.1k6 gold badges74 silver badges97 bronze badges

Comments

zion ben yacov · Accepted Answer · 2011-10-24 14:44:19Z

0

SELECT * FROM accounts LEFT JOIN players USING (name) WHERE accounts.id = 'value';

answered Oct 24, 2011 at 14:44

zion ben yacov

7356 silver badges13 bronze badges

Comments

Mike Neugebauer · Accepted Answer · 2011-10-24 14:27:30Z

-1

You'll need a query that looks like this (this is known in SQL as a subselect):

"SELECT p.* FROM players p WHERE name IN ( SELECT n.name FROM accounts n WHERE n.id = '$val' )"

edited Oct 24, 2011 at 14:27

answered Oct 24, 2011 at 14:25

Mike Neugebauer

335 bronze badges

1 Comment

Rudi Visser Over a year ago

A subselect is a bad way to do this for several reasons, a join is more than suffice.

Collectives™ on Stack Overflow

php mysql join query

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related