title: Group By Timestamp day isn't returning any results
body: <p>HI I have a table which has a time stamp column in it, what i am trying to do is group the results of the table by day and count how many entries exist in that table for that day along with a list of timestamps.</p>
  
  <p>Below is the code i am using it but it isn't returning any results.</p>
  
  <pre><code> $query1 = "SELECT COUNT(*),  DAYOFYEAR(timestamp) FROM all_count GROUP BY   DAYOFYEAR(timestamp)";
   $result = mysql_query($query1);
   while($row = mysql_fetch_array($result))
   {
   echo $row['timestamp'];    
   echo $row['count'];
   }
  </code></pre>