연도별 group by 해서 목록 노출

 

 

$lst_sql    = "SELECT *
,(SELECT COUNT(y_year)) AS cnt
FROM (SELECT * FROM year_tbl WHERE y_type='2')a GROUP BY y_year DESC";
$res = $db->get_results($lst_sql);

# Create HTML #################################################################
if ($res)
{
  $HTML_TAG = "";
  
  foreach ($res as $data)
  {
    $data->y_content = stripslashes($data->y_content);
    $HTML_TAG .="<tr>";
    $HTML_TAG .="<td>";
    $HTML_TAG .="<ul>";

    $sql = "SELECT * FROM year_tbl WHERE y_year = $data->y_year AND y_type = '2'  ORDER BY y_year DESC, y_month+0 DESC, y_content ASC";
    $lst_res = $db->get_results($sql);

    foreach ($lst_res as $data2)
    {
    	$HTML_TAG .="<li>{$data2->y_content}</li>";
    }

    $HTML_TAG .="</ul>";
    $HTML_TAG .="</td>";
    $HTML_TAG .="</tr>";
  }
}