How can the use of DISTINCT in a SELECT query help in avoiding duplicate results in PHP?

When querying a database in PHP using SELECT, the DISTINCT keyword can be used to eliminate duplicate rows from the result set. This can be helpful when you want to retrieve unique values from a column or set of columns, preventing repetitive data from being displayed. By using DISTINCT, you can ensure that only distinct values are returned in the query result. 

<?php
// Establish a connection to the database
$connection = new mysqli("localhost", "username", "password", "database");

// Query the database to retrieve distinct values from a specific column
$query = "SELECT DISTINCT column_name FROM table_name";
$result = $connection->query($query);

// Loop through the result set and display the unique values
while ($row = $result->fetch_assoc()) {
    echo $row['column_name'] . "<br>";
}

// Close the database connection
$connection->close();
?>

Keywords

DISTINCT SELECT query duplicate results PHP avoiding

Related Questions