PHP

how to remove duplicate data in php

$array = array(1, 2, 2, 3);
$array = array_unique($array); // Array is now (1, 2, 3)

php query to hide duplicate records

For example

First, orderby grouping row and then add other orderby columns:

order by keyword, day;

second, skip the similar elements in loop:

if ($result = $mysqli->query($query)) {
    $last_keyword = null;
    // fetch associative array
    while ($row = $result->fetch_assoc()) {
        if($row["keyword"] != $last_keyword){
             // print the changed keyword
             echo $row["keyword"];
             // set the last keyword to the new keyword
             $last_keyword = $row["keyword"];
        }
        // do your other listings here
    }

    // free result set
    $result->free();
}