<?php
$list_programming_language = array('C#', 'C++', 'PHP', 'C#', 'PHP');
$result = array_unique($list_programming_language);
print_r($result);
?>
// ==> 'C#', 'C++', 'PHP'
<?php
$input = array("a" => "green", "red", "b" => "green", "blue", "red");
$result = array_unique($input);
print_r($result);
?>
Array
(
[a] => green
[0] => red
[1] => blue
)
<?php
$fruits_list = array('Orange', 'Apple', ' Banana', 'Cherry', ' Banana');
$result = array_unique($fruits_list);
print_r($result);
?>
$array = array(1, 2, 2, 3);
$array = array_unique($array); // Array is now (1, 2, 3)
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();
}
$str = implode(',',array_unique(explode(',', $str)));