Select dates from DB but showing only one in case of same data [duplicate]

Question

How to retrieve one time the arrival date of flight from a table even if other rows has the same date. Here my code

$sql = "SELECT arrFlight FROM flights";
$ data = mysqli_query($conn, $sql);
foreach($data as $date){
echo $date['arrFlight'] . </br>;
}

Here is the response

Now how can I retrieve only one time the dates that has same value?

Gaurav · Accepted Answer · 2019-02-10 13:48:20Z

2

Use group by / distinct in sql.

$sql = "SELECT arrFlight FROM flights group by arrFlight";

answered Feb 10, 2019 at 13:48

Gaurav

1,09910 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zahid Hassan Shaikot · Accepted Answer · 2019-02-10 13:49:23Z

1

Try this query

$sql = "SELECT DISTINCT  arrFlight FROM flights";

OR

 $sql = "SELECT arrFlight FROM flights GROUP BY arrFlight";

Rather then

$sql = "SELECT arrFlight FROM flights";

answered Feb 10, 2019 at 13:49

1,3581 gold badge11 silver badges19 bronze badges