matthijs110 Posted May 11, 2014 Share Posted May 11, 2014 Hello, How can I select multiple SQL tables? For example like this: $result = mysqli_query($con, "SELECT Username, Wins FROM Table1, Table2 ORDER BY Wins DESC"); I want to use it in 1: while ($row = mysqli_fetch_assoc($result)) { I know this is possible, but I can't find a clear way. Link to comment https://forums.phpfreaks.com/topic/288409-select-multiple-sql-tables-for-1-while-loop/ Share on other sites More sharing options...
davidannis Posted May 11, 2014 Share Posted May 11, 2014 You need to use the mysql JOIN http://dev.mysql.com/doc/refman/5.0/en/join.html Link to comment https://forums.phpfreaks.com/topic/288409-select-multiple-sql-tables-for-1-while-loop/#findComment-1479081 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.