https://business.forums.bt.com/t5/Archive/question-about-mysql/m-p/50824#M14905 <DIV>So I have mysql db with 2 tables<BR /><BR />1 table "player"<BR />id | player name<BR /><BR />and the other table "playerdata"<BR /><BR />player_id | data | etc<BR /><BR /><BR />How can I make a single sql query that takes a specified playername and looks it up in the first table, and then uses that players 'id' in the 2nd table "playerdata"<BR /><BR />Pretty new to mysql and php(somewhat anyway)<BR /><BR />I can do it by making 2 queries, but I was wondering if it isn't just possible to make mysql do the extra working in finding that players id and then using it.</DIV><DIV>&nbsp;</DIV><DIV>Thanks<IMG src="http://imagicon.info/cat/12-1/text-smiley.png" border="0" /></DIV> Mon, 11 Feb 2013 18:56:32 GMT orthohin 2013-02-11T18:56:32Z https://business.forums.bt.com/t5/Archive/question-about-mysql/m-p/50824#M14905 <DIV>So I have mysql db with 2 tables<BR /><BR />1 table "player"<BR />id | player name<BR /><BR />and the other table "playerdata"<BR /><BR />player_id | data | etc<BR /><BR /><BR />How can I make a single sql query that takes a specified playername and looks it up in the first table, and then uses that players 'id' in the 2nd table "playerdata"<BR /><BR />Pretty new to mysql and php(somewhat anyway)<BR /><BR />I can do it by making 2 queries, but I was wondering if it isn't just possible to make mysql do the extra working in finding that players id and then using it.</DIV><DIV>&nbsp;</DIV><DIV>Thanks<IMG src="http://imagicon.info/cat/12-1/text-smiley.png" border="0" /></DIV> Mon, 11 Feb 2013 18:56:32 GMT https://business.forums.bt.com/t5/Archive/question-about-mysql/m-p/50824#M14905 orthohin 2013-02-11T18:56:32Z