How can you prevent duplicate values from being displayed in a PHP query result?

When running a PHP query, you can prevent duplicate values from being displayed by using the DISTINCT keyword in your SQL query. This keyword ensures that only unique values are returned in the result set. By including DISTINCT in your query, you can eliminate any duplicate values that may be present in the database table. 

$query = "SELECT DISTINCT column_name FROM table_name";
$result = mysqli_query($connection, $query);

if(mysqli_num_rows($result) > 0){
    while($row = mysqli_fetch_assoc($result)){
        echo $row['column_name'] . "<br>";
    }
}

Keywords

PHP query duplicate values DISTINCT database

Related Questions