Daterange sorted by date and group by hour

I have a msql table that has data input ever hour of every day, so each date is entered 24 times and then a hour field as seen below...

How do I get the information between a daterange ?

Here is what I have, but I think the time is stopping it from working...

$sql = "SELECT * FROM report WHERE date BETWEEN '$start' AND '$end'";

Hee is the table I want to get information by the date...

unit ID | Date | Time | Power | Volts | Current |

1         10/15/2010    21:00:00         0            220          100
1         10/开发者_JS百科15/2010    22:00:00         0            220          100
1         10/15/2010    23:00:00         0            220          100
1         10/16/2010    00:00:00         0            220          100
1         10/16/2010    01:00:00         0            220          100
1         10/16/2010    02:00:00         0            220          100
1         10/16/2010    03:00:00         0            220          100
1         10/16/2010    04:00:00         0            220          100
1         10/16/2010    05:00:00       245            220          100
1         10/16/2010    06:00:00       360            220          100
1         10/16/2010    07:00:00       596            220          100
1         10/16/2010    08:00:00      1567            220          100
1         10/16/2010    09:00:00      1568            220          100
1         10/16/2010    10:00:00      1598            220          100
1         10/16/2010    11:00:00      1642            220          100
1         10/16/2010    12:00:00      1658            220          100
1         10/16/2010    13:00:00      1664            220          100
1         10/16/2010    14:00:00      1598            220          100
1         10/16/2010    15:00:00      1527            220          100
1         10/16/2010    16:00:00       980            220          100
1         10/16/2010    17:00:00       410            220          100
1         10/16/2010    18:00:00       208            220          100
1         10/16/2010    19:00:00         0            220          100
1         10/16/2010    20:00:00         0            220          100
1         10/16/2010    21:00:00         0            220          100
1         10/16/2010    22:00:00         0            220          100
1         10/16/2010    23:00:00         0            220          100
1         10/17/2010    00:00:00         0            220          100
1         10/17/2010    01:00:00         0            220          100
1         10/17/2010    02:00:00         0            220          100

The Date is DATE, the Time field is TIME, Power, Volt and Current are FLOAT.

The $start and $end are dates from a datepicker

    $start = (isset($_POST['start1'])) ? date("Y-m-d",strtotime($_POST['start1'])) : date("Y-m-d");

$end   = (isset($_POST['end1'])) ? date("Y-m-d",strtotime($_POST['end1'])) : date("Y-m-d");

No, if you want all the points from all the dates, you can ignore you time column and your query will work just fine.

You need to remove the single (') quotes from the variables $start and $end.

By using single quotes, you are making your variables a string.

Just use

$sql = "SELECT * FROM report WHERE date BETWEEN $start AND $end";

In your mysql table the date is in the format m-D-Y, whereas in your php code, its Y-m-d. The date format in ur php code should be similar to your mysql date format.