$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>";
}
}
'php개발자(백엔드) > php' 카테고리의 다른 글
php 앞글자 가져오기 (0) | 2019.06.03 |
---|---|
php 동시로그인 방지 개발하기(초간단) (3) | 2019.05.09 |
php resize png black background (0) | 2019.04.04 |
var_dump (0) | 2017.01.12 |
$_FILES [엑셀업로드 관련] (0) | 2016.12.01 |