How about this...
Text Formatted Code
$enddate = mktime(0,0,0,$DE[1],$DE[2],$DE[0]) + 3600;
$sql .= "AND (UNIX_TIMESTAMP(date) BETWEEN '$startdate' AND '$enddate') ";
>>>
$enddate = mktime(23,59,59,$DE[1],$DE[2],$DE[0]);
$sql .= "AND (date BETWEEN '$startdate' AND '$enddate') ";
Text Formatted Code
$enddate = mktime(0,0,0,$ed[1],$ed[2],$ed[0]) + 3600;
$sqltmp .= " AND date BETWEEN '$startdate' AND '$enddate'";
>>>
$enddate = mktime(23,59,59,$ed[1],$ed[2],$ed[0]);
$sqltmp .= " AND (date BETWEEN '$startdate' AND '$enddate')";