How can the results of a LEFT JOIN query in PHP be sorted to display all records from one table and only matching records from another table?

When using a LEFT JOIN query in PHP, all records from the left table are displayed along with matching records from the right table. To sort the results to display all records from the left table and only matching records from the right table, you can add a WHERE clause to filter out NULL values from the right table's columns. This will ensure that only matching records are included in the final result set. 

$query = "SELECT * FROM table1 LEFT JOIN table2 ON table1.id = table2.id WHERE table2.id IS NOT NULL";
$result = mysqli_query($conn, $query);

if (mysqli_num_rows($result) > 0) {
    while ($row = mysqli_fetch_assoc($result)) {
        // Process each row as needed
    }
}

Keywords

LEFT JOIN sorting PHP MySQL matching records

Related Questions