ShoeLace1291 Posted December 4, 2007 Share Posted December 4, 2007 I have a table of data that stores recent match results. There's a column called "participants". I've seen on forum softwares that list certain data. For example, say players 1, 2, 3, and 4 play in the match. The data inserted will be 1, 2, 3, 4 How would I get the players' information from a table called "members" based on the member id's listed in the participants column of the matches table? Quote Link to comment https://forums.phpfreaks.com/topic/80079-how-would-i-do-this/ Share on other sites More sharing options...
PHP_PhREEEk Posted December 4, 2007 Share Posted December 4, 2007 That's a purely MySQL question... you'd be better off posting it over there... PhREEEk Quote Link to comment https://forums.phpfreaks.com/topic/80079-how-would-i-do-this/#findComment-405839 Share on other sites More sharing options...
GingerRobot Posted December 4, 2007 Share Posted December 4, 2007 You can either do a join or a sub query. If you google, you'll find plently of examples. Quote Link to comment https://forums.phpfreaks.com/topic/80079-how-would-i-do-this/#findComment-405910 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.