How can you optimize PHP code to avoid displaying duplicate values from a database column?

To avoid displaying duplicate values from a database column in PHP, you can use the `DISTINCT` keyword in your SQL query to retrieve unique values only. This will ensure that each value is displayed only once, eliminating duplicates in the output. 

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

// Check connection
if ($connection->connect_error) {
    die("Connection failed: " . $connection->connect_error);
}

// Select unique values from a specific column
$sql = "SELECT DISTINCT column_name FROM table_name";
$result = $connection->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo $row["column_name"] . "<br>";
    }
} else {
    echo "0 results";
}

$connection->close();
?>

Keywords

PHP optimization database duplicate values column

Related Questions