fetch_object($sql);
$total_cnt = $row->cnt;
$sql = "SELECT *
FROM case_study
WHERE 1=1
{$search_sql}
ORDER BY sort_no
{$limit}
";
$result = $db->query($sql);
$number = $total_cnt - ($limit_cnt * ($page-1));
while($row = mysqli_fetch_object($result)) {
$no = $row->no;
$title=$row->title;
//$contents = $row->contents;
$category = $row->category;
$reg_date = substr($row->reg_date,0,10);
$img_folder_1 = $row->img_folder_1;
$img_name_1 = $row->img_name_1;
//if($img_name_1) $attach_str_1= '
';
$attach_str_1= $img_folder_1."/".makeThumbCrop($img_name_1, $CASE_MAIN_CROP);
$category_str = "";
if($category) {
$sub_sql = "SELECT *
FROM case_category
WHERE no IN ($category)
";
$sub_result = $db->query($sub_sql);
while($sub_row = mysqli_fetch_object($sub_result)) {
if($category_str) $category_str .= " ";
$category_str .= $sub_row->category_name;
}
}
?>