Want to display only rows with selected value using sql and php

Question

I have 40 providers and 10,000 products, but I want to show 1 product from each provider

Brand	Provider	Products	URL
Lightning	Pragmatic Game	Mrs. Destiny	Link
Lightning	Isoftbet	Halloween Jack	Link
Lightning	Pragmatic Game	Sweet Bonanza	Link
Lightning	Isoftbet	Tropical Security	Link
Lightning	Network	Royal Potato	Link
Lightning	Network	Mrs. Destiny	Link

This is my current SQL table.But I want to display 1 item per provider, for example:

Brand	Provider	Products	URL
Lightning	Pragmatic Game	Mrs. Destiny	Link
Lightning	Isoftbet	Halloween Jack	Link
Lightning	Network	Royal Potato	Link

This is my code `

<?php
/* Attempt MySQL server connection. Assuming you are running MySQL
server with default setting (user 'root' with no password) */
$link = mysqli_connect("localhost", "newuser1", "p, Dn@auTD3$*G5", "newdatabse");

// Check connection
if($link === false){
    die("ERROR: Could not connect. " . mysqli_connect_error());
}// Attempt select query execution
$sql = "SELECT * FROM tablename WHERE Brand='Coolcasino' and Provider IN ('Pragmatic Play','Isoftbet','Netent') ;";
if($result = mysqli_query($link, $sql)){
    if(mysqli_num_rows($result) > 0){
        echo "<table>";
            echo "<tr>";
                echo "<th>Brand</th>";
                echo "<th>Provider</th>";
                echo "<th>Product</th>";
                echo "<th>URL</th>";
            echo "</tr>";
        while($row = mysqli_fetch_array($result)){
            echo "<tr>";
                echo "<td>" . $row['Brand'] . "</td>";
                echo "<td>" . $row['Provider'] . "</td>";
                echo "<td>" . $row['Product'] . "</td>";
                echo "<td>" . $row['URL'] . "</td>";
            echo "</tr>";
        }
        echo "</table>";
        // Close result set
        mysqli_free_result($result);
    } else{
        echo "No records matching your query were found.";
    }
} else{
    echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

// Close connection
mysqli_close($link);
?>

如果有人可以的话请帮助我`

Answer 1

Replace your query with

$sql = "SELECT * FROM tablename WHERE Brand='Coolcasino' and Provider IN ('Pragmatic Play','Isoftbet','Netent') GROUP BY  Provider;";

Answer 2

Use line number:

select Brand,
       Provider,
       Product,
       URL
from (   select Brand,
                Provider,
                Product,
                URL,
                row_number() over(partition by Provider order by rand()) as row_num
         from tablename
         where Brand='Lightning' 
         and Provider IN ('Pragmatic Play','Isoftbet','Netent') 
      ) as rand_prod
where row_num=1;

https://dbfiddle.uk/BGzx6cYY

Note, I recommend not to use select *, select only the columns you really need