What are some best practices for combining two SQL queries with different numbers of SELECT fields in PHP?

When combining two SQL queries with different numbers of SELECT fields in PHP, one common approach is to use UNION to merge the results of the two queries. However, it is important to ensure that the number and data types of the selected fields match in both queries to avoid errors. Another approach is to use a JOIN operation if there is a common field between the two queries. 

<?php

// Assuming $conn is the database connection

$query1 = "SELECT field1, field2 FROM table1";
$query2 = "SELECT field3 FROM table2";

$result = mysqli_query($conn, $query1);
$result2 = mysqli_query($conn, $query2);

if ($result && $result2) {
    while ($row = mysqli_fetch_assoc($result)) {
        // Access data from query1
        echo $row['field1'] . " " . $row['field2'] . "<br>";
    }
    
    while ($row2 = mysqli_fetch_assoc($result2)) {
        // Access data from query2
        echo $row2['field3'] . "<br>";
    }
} else {
    echo "Error: " . mysqli_error($conn);
}

mysqli_close($conn);

?>

Keywords

PHP SQL queries combining different numbers of SELECT fields best practices

Related Questions