So I have mysql db with 2 tables
1 table "player"
id | player name
and the other table "playerdata"
player_id | data | etc
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"
Pretty new to mysql and php(somewhat anyway)
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.
1 table "player"
id | player name
and the other table "playerdata"
player_id | data | etc
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"
Pretty new to mysql and php(somewhat anyway)
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.
Thanks
