webdevdea Posted October 22, 2013 Share Posted October 22, 2013 I need to get the team nickname to display so I can have a list of players by team.. the Nickname is in the dRcontract table.. if ($result = $mysqli->query("SELECT p.pid, p.firstname, p.lastname FROM dRplayer p, dRcontract c WHERE c.pid = p.pid ")) Link to comment https://forums.phpfreaks.com/topic/283193-mysql-join-help/ Share on other sites More sharing options...
Ch0cu3r Posted October 22, 2013 Share Posted October 22, 2013 No idea but try if ($result = $mysqli->query("SELECT p.pid, p.firstname, p.lastname, c.Nickname FROM dRplayer p, dRcontract c WHERE c.pid = p.pid ")) Link to comment https://forums.phpfreaks.com/topic/283193-mysql-join-help/#findComment-1454971 Share on other sites More sharing options...
webdevdea Posted October 22, 2013 Author Share Posted October 22, 2013 That worked…..:-) now to get it to group? Link to comment https://forums.phpfreaks.com/topic/283193-mysql-join-help/#findComment-1454975 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.