So im working with morris charts, im showing all the data we have for today.
I have an array like below:
[0] => Array (
[id] => 1
[uid] => 6161
[botted] => 0
[crondate] => 2016-06-08 00:20:32
)
[1] Array (
[id] => 2
[uid] => 4141
[botted] => 140
[crondate] => 2016-06-08 00:40:00
)
[2] Array (
[id] => 3
[uid] => 53
[botted] => 40
[crondate] => 2016-06-08 01:12:20
)
[3] Array (
[id] => 4
[uid] => 5
[botted] => 140
[crondate] => 2016-06-08 01:18:00
)
[4] Array (
[id] => 5
[uid] => 353
[botted] => 88
[crondate] => 2016-06-08 01:50:00
)
(I hand writ the array, its a result of a SELETE * FROM items QUERY)
I need all of the rows formatted by date then added to seperate arrays depending on the date.
I need them formated by the hour, example:
All of the rows with the date inside of 1pm today, added to an array FOR THAT HOUR.
All of the rows with the date inside of 2pm today, added to an array FOR THAT HOUR.
etc, etc...
I need this done for every hour of the day(up to the current hour) so that i can add up all of the ['botted'] columns for that hour, add that to an array and display it in a MORRIS CHART
Thank you.
</div>