title: Group by timestamp MYSQL outputting blank rows
body: <p>I have a MYSQL Query of which is returning blank rows for each row returned.</p>
  
  <p>The data is not echoing, but the rows are. I have no idea why this is occurring. </p>
  
  <p>Why is this not working correctly?</p>
  
  <p><strong>The MySQL/PHP</strong></p>
  
  <pre><code>$sql6x = " SELECT date(datetime), sum(row_total)
                   FROM sales_tickets
                   GROUP BY date(datetime);
                                  "; 
                  $result6x = mysql_query($sql6x);
  
                  while ($row6x = mysql_fetch_array($result6x)) { 
                       echo $datetime = $row6x['datetime'].$br;   
                       echo $row_total = $row6x['row_total'].$br; 
                  }
  </code></pre>