如何获取MySQL的最新记录日期？ [关闭]

Question

This is my MySQL table:

p_id    product_name          description           added_date
-----------------------------------------------------------------------
1       headphone               headphone         2012-06-23 10:20:11
2       cdplayer                cdplayer          2012-06-23 12:03:51
3       computerbag            computerbag        2012-06-23 04:10:38
4       lcd                       lcd             2012-06-23 08:40:15
5       monitor                  monitor          2012-06-10 05:11:55
6       mouse                     mouse           2012-06-10 09:12:45
7       lasermouse              lasermouse        2012-06-10 11:54:12
8       keyboard                 keyboard         2012-05-28 07:18:21
9       camera                    camera          2012-05-28 10:20:11
10      charger                   charger         2012-05-28 10:55:33

I want my results to look like:

23 Jun

• headphone
• cdplayer
• computerbag
• lcd

10 Jun

• monitor
• mouse
• lasermouse

28 May

• keyboard
• camera
• charger

Answer 1

This is not exactly the format you want. You have to change a little bit in formatting for example with <ul> and <li> tags.

<?php
$con = mysqli_connect... //Database connection
$result = mysqli_query($con, "SELECT product_name,DATE(added_date) AS only_date FROM YOURTABLENAME ORDER BY DATE(added_date) DESC,p_id ASC");

$currentDate = "";
while($data = mysqli_fetch_object($result)) {
    if($currentDate != $data->only_date) {
        echo $data->only_date."<br>"; //You have to format this, now it's YYYY-MM-DD
        $currentDate = $data->only_date;
    }
    echo $data->product_name."<br>";
}  
?>