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? 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 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. 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
Archived
This topic is now archived and is closed to further replies.