使用PHP MySql的高级新闻档案年/月(Advanced news archive Years/Month using PHP MySql)

 我在MySQL数据库中插入带有timestamp的新闻日期。 现在我需要为我的新闻提供高级存档像这样： 
 
2013

    July (4)
         News 1 
         News 2 
         News 3 
         News 4 
    December (2)
         News 1 
         News 2 
    NovemberPrint (4)
         News 1 
         News 2 
         News 3 
         News 4 
2014
    January (8)
         News 1 
         News 2 
         News 3 
         News 4 
         News 5 
         News 6 
         News 7 
         News 8
 
 现在我需要任何PHP function和MySQL SELECT结构来使用PDO或MySQL Query进行打印。 
 
 在线示例在这里 
 
 编辑：我从这里发现了这个问题： 
 
$sql = "SELECT YEAR(FROM_UNIXTIME(timestamp)) AS YEAR, 
                MONTHNAME(FROM_UNIXTIME(timestamp)) AS MONTH, 
                COUNT(*) AS TOTAL 
         FROM NEWS GROUP BY YEAR, MONTH ORDER BY YEAR DESC, MONTH ";
$newsdata = DataAccess::ArrayFetch($sql);

$currentYear = null;

foreach($newsdata AS $news){            
  if ($currentYear != $news['YEAR']){
    echo '<h2>'.$news['YEAR'].'<h2>';
    $currentYear = $news['YEAR'];
  }
 echo '<dd>'.$news['MONTH'].'<dd><dt>'.$news['TOTAL'].'</dt>';
} 
 
 但是，此仅打印计数和GROUP By Years ad Month。 我需要在每个月之后列出文章。 

I insert date of news with timestamp in MySQL database. Now I need to advanced archive for my news Like This :
 
2013

    July (4)
         News 1 
         News 2 
         News 3 
         News 4 
    December (2)
         News 1 
         News 2 
    NovemberPrint (4)
         News 1 
         News 2 
         News 3 
         News 4 
2014
    January (8)
         News 1 
         News 2 
         News 3 
         News 4 
         News 5 
         News 6 
         News 7 
         News 8
 
Now I need any PHP function and MySQL SELECT structure for print this using PDO Or MySQL Query.
 
Online Example HERE
 
EDIT: I found This Ask From Here: 
 
$sql = "SELECT YEAR(FROM_UNIXTIME(timestamp)) AS YEAR, 
                MONTHNAME(FROM_UNIXTIME(timestamp)) AS MONTH, 
                COUNT(*) AS TOTAL 
         FROM NEWS GROUP BY YEAR, MONTH ORDER BY YEAR DESC, MONTH ";
$newsdata = DataAccess::ArrayFetch($sql);

$currentYear = null;

foreach($newsdata AS $news){            
  if ($currentYear != $news['YEAR']){
    echo '<h2>'.$news['YEAR'].'<h2>';
    $currentYear = $news['YEAR'];
  }
 echo '<dd>'.$news['MONTH'].'<dd><dt>'.$news['TOTAL'].'</dt>';
} 
 
But, This Print Only Count and GROUP By Years ad Month. I need to listed article after each month.

原文：https://stackoverflow.com/questions/20957249