I am having so much trouble with this. I am trying to get the maximum value per day given the range. But I keep getting a blank value in my count column when I load the query result.

```
<?php

include("dbconnect.php");   

$link=Connection();

$data1 = '2016-04-29 00:00:00';
$data2 = '2016-05-02 00:00:00';

$result = mysql_query(
                          "
                          SELECT DATE(orderDate), MAX(Count)
                          FROM testLocation 
                          WHERE orderDate 
                          BETWEEN '$data1%' AND '$data2%'
                          GROUP BY DATE(orderDate)
                          "
                          ,$link
                          );
?>

```