<?php
$arr = array(
array('date' => '09-04-2018','item' => 'player 1', 'score' => '1'),
array('date' => '09-04-2018','item' => 'player 2', 'score' => '2'),
array('date' => '10-04-2018','item' => 'player 1', 'score' => '1'),
array('date' => '10-04-2018','item' => 'player 2', 'score' => '2'),
array('date' => '16-04-2018','item' => 'player 1', 'score' => '3'),
array('date' => '16-04-2018','item' => 'player 2', 'score' => '4'),
array('date' => '17-04-2018','item' => 'player 1', 'score' => '3'),
array('date' => '17-04-2018','item' => 'player 2', 'score' => '4')
);
//Week example
Foreach($arr as $val){
$res[$val['item']][date("F", strtotime($val['date']))][] = $val['score'];
}
Var_dump($res);
preferences:
30.03 ms | 406 KiB | 5 Q