What steps can be taken to ensure that each image is only displayed once in a table generated from a MySQL database query in PHP?

To ensure that each image is only displayed once in a table generated from a MySQL database query in PHP, you can use the DISTINCT keyword in your SQL query to retrieve only unique images. This will prevent duplicate images from being displayed in the table. 

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

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

// SQL query to retrieve unique images
$sql = "SELECT DISTINCT image FROM images_table";
$result = $conn->query($sql);

// Display images in a table
if ($result->num_rows > 0) {
    echo "<table>";
    while($row = $result->fetch_assoc()) {
        echo "<tr><td><img src='" . $row["image"] . "'></td></tr>";
    }
    echo "</table>";
} else {
    echo "0 results";
}

$conn->close();
?>

Keywords

MySQL PHP DISTINCT array_unique SQL query

Related Questions