What best practices should be followed when selecting only one value per name from a database in PHP?

When selecting only one value per name from a database in PHP, it is best practice to use a GROUP BY clause in your SQL query to group the results by name and then select only one value per name. This ensures that each name is represented only once in the result set. 

<?php
// Connect to the database
$conn = new mysqli($servername, $username, $password, $dbname);

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

// Select one value per name from the database
$sql = "SELECT name, MAX(value) AS value FROM table_name GROUP BY name";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // Output data of each row
    while($row = $result->fetch_assoc()) {
        echo "Name: " . $row["name"]. " - Value: " . $row["value"]. "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

SQL DISTINCT GROUP BY PDO MySQL

Related Questions