I have been starting at this problem blankly for a couple hours now. Hopefully someone can help. I have a query that returns an event count grouped by hour: timestamp: Array ( [0] => 2010-09-08 03 [1] => 2010-09-08 04 [2] => 2010-09-08 05 [3] => 2010-09-08 06 [4] => 2010-09-08 07 [5] => 2010-09-08 08 [6] => 2010-09-08 09 [7] => 2010-09-08 10 [8] => 2010-09-08 11 [9] => 2010-09-08 12 [10] => 2010-09-08 13 [11] => 2010-09-08 14 [12] => 2010-09-08 15 [13] => 2010-09-08 16 ) 24 event count: Array ( [0] => 1731 [1] => 885 [2] => 544 [3] => 668 [4] => 748 [5] => 754 [6] => 933 [7] => 2422 [8] => 6713 [9] => 31925 [10] => 18827 [11] => 16743 [12] => 16875 [13] => 11775 ) Lets say that coming into this, I knew that the query spanned 36 hours and started at 01:00. How can I manipulate the resulting array to contain the missing time stamps and a value of 0. The effect I am shooting for looks like this: http://www.pintumbler.org/example.png So 0 - > 23 will be static and I just walk through the array and populate those. If we hit 23, start a new row and continue. The matrix will always be the same though. I think I know what needs to happen, I just cant come up with the logic. Any push in the right direction would be appreciated. -- Paul Halliday Ideation | Individualization | Learner | Achiever | Analytical http://www.pintumbler.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
