PHP collect and combine different data from two tables

Question

I have these two tables which I'm trying to make an output of. The first one **USERS** stores all information about a user, including an unique ID (androidID). The second one gets input based on number of laps a user has taken, and will make one row pr lap.

What I'm trying to do is to output the last entry of a given androidID in **ROUNDS**, whith the corresponding name etc. from **USERS**

_____________________        _________________________
|    **USERS**      |        |      **ROUNDS**       |
---------------------        -------------------------
| NAME              |        | ID(unique)            |
| LASTNAME          |        | TIME                  |
| androidID(unique) | <----> | androidID(NOT unique) |
| ...               |        | ROUNDS                |

This is how I'm quering the server

$result_users = $con->query(
    "SELECT * FROM users"
);

$result_rounds = $con->query(
    "SELECT * FROM Rounds ORDER BY laps desc"
);

I tried to numerous combination of the following. With no luck. My PHP skills is not the best, I'm afraid.

foreach ($result_users as $row_users) {
    foreach ($result_rounds as $row_rounds) {
         if($row_users['androidID'] == $row_rounds['androidID'] {
             // Do some wizzardy
         }
    }
}

I have really hit a wall trying to connect the tables.

Answer 1

This would be the sql statement you want in your query.

SELECT * FROM `**USERS**` LEFT JOIN `**ROUNDS**`ON `**USERS**`.`androidID` = `**rounds**`.`androidID` ORDER BY `laps` desc 0,1;