php + mysql =选择并显示不同日期的行

ORDER BY

SELECT *
FROM `clicks_log`
ORDER BY `date` ASC;

// Get the first date
$dateSection = ...;
while ($row = mysql_fetch_assoc($result)) {
    ...

    // Check here if the date header has changed to begin a new section
    $dateHeader = date(\"d.m.Y\", $row[\'date\']);
    if ( $dateHeader !== $dateSection ) {
        // Build new section header here
        ...
        $dateSection = $dateHeader;
    }

    ...
    echo $row[\'ip\'];
    ...
    echo date(\"H:i, d.m.Y\", $row[\'date\']);
    ...
}

$dateSection

$result

where tbl.`date` between FROM_UNIXTIME( \' . $a . \') AND FROM_UNIXTIME( \' . $b . \');\';

for ($i = 15; $i <= $current_day_of_month; $i++) {
        // SELECT * FROM clicks_log WHERE DATE LIKE \'% $i.04.2011\' ORDER BY DATE ASC;
        // print the result
}

 $sql = \"SELECT ip, date FROM clicks_log table ORDER BY date ASC\";

 $date = date_parse($row[\'date\']);
 $year = $row[\'year\'];
 $month = $row[\'month\'];
 $day = $row[\'day\'];