What is the best way to output multiple identical data only once in PHP when retrieving data from a mixed database table?

When retrieving data from a mixed database table in PHP, you may encounter the need to output multiple identical data only once. To achieve this, you can use an array to store the unique values and then check if a value has already been output before displaying it. This way, you can avoid displaying duplicate data. 

// Sample code to output multiple identical data only once
$uniqueValues = array();

// Assuming $results is the array of data retrieved from the database
foreach ($results as $result) {
    $value = $result['value'];

    // Check if the value has already been output
    if (!in_array($value, $uniqueValues)) {
        echo $value . "<br>";
        $uniqueValues[] = $value;
    }
}

Keywords

PHP database query DISTINCT deduplication

Related Questions