Saturday 15 January 2011

mysql - How to agregate/group php array by SQL timedate/unix timestamp? -


How to count data from the array MySQL timed format or from unix timestamps to hours?

My array:

  array ([0] = & gt; array ([0] => ID [1] => name [2] = & Gt; 2013-01-10 00:36: 00) [1] = & gt; Array ([0] => ID [1] = & gt; [2] => 2013-01 -10 00:36:00))   

How to shrink thousands of things like this and somehow cling to them hours or even days? I only need some number of rows over time given in the specific day.

SELECT * see table HOUR (date_column) WHERE status ... < P>

No comments:

Post a Comment