= '3' and mb_1 <> '' $mb_business $sql_search ";
$sql_cnt = sql_fetch($sql);//프리미엄 업체
$total_count = $sql_cnt[cnt];
$page_rows = 20;
$total_page = ceil($total_count / $page_rows); // 전체 페이지 계산
if ($page < 1) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $page_rows; // 시작 열을 구함
$list_pages = preg_replace('/(\.php)(&|&)/i', '$1?', get_paging(10, $page, $total_page, './address_main.php'.$qstr.'&page='));
// 모바일
if(G5_IS_MOBILE) {
include_once(G5_THEME_MOBILE_PATH.'/head.php');
?>
주소록 회원사 주소 안내입니다.
상호 |
주소 |
연락처 |
= '3' and mb_1 <> '' $mb_business $sql_search order by b.wr_datetime desc limit $from_record, $page_rows ";
// echo $sql;
$result = sql_query($sql);
while($row=sql_fetch_array($result)){
$index = $index + 1;
switch($row["mb_level"]){
case "3":
$_level = "비즈회원";
break;
case "4":
$_level = "프리미엄 회원";
break;
case "5":
$_level = "전문가 상담회원";
break;
case "6":
$_level = "전문가 상담회원";
break;
default:
$_level = "-";
break;
}
$_nowdate = date("Y-m-d");
$promotion_ing = " and ('{$_nowdate}' >= str_to_date(wr_5, '%Y-%m-%d') and '{$_nowdate}' <= str_to_date(wr_6, '%Y-%m-%d')) "; // 진행중
$tmp_write_table = $g5['write_prefix'] . 'coupon'; // 쿠폰
$sql = " SELECT COUNT(1) AS `cnt` FROM {$tmp_write_table} where wr_is_comment = 0 and mb_id = '".$row['mb_id']. "' {$promotion_ing} ";
$coupon_row = sql_fetch($sql);
$coupon_count = $coupon_row['cnt'];
$_nowdate = date("Y-m-d H:i");
$promotion_ing = " and ('{$_nowdate}' >= str_to_date(concat(wr_5, ' ', wr_7), '%Y-%m-%d %H:%i') and '{$_nowdate}' <= str_to_date(concat(wr_5, ' ', wr_8), '%Y-%m-%d %H:%i')) "; // 진행중
$tmp_write_table = $g5['write_prefix'] . 'lightning'; // 번개
$sql = " SELECT COUNT(1) AS `cnt` FROM {$tmp_write_table} where wr_is_comment = 0 and mb_id = '".$row['mb_id']. "' {$promotion_ing} ";
$lightning_row = sql_fetch($sql);
$lightning_count = $lightning_row['cnt'];
?>
" style="color:#183d7e; font-weight:bold;">
=$row["mb_1"];?>
0 || $lightning_count > 0) {
echo '프로모션';
}
?>
|
">
=$row["mb_6"];?> |
=$row["mb_3"];?> |
게시물이 없습니다. | '; } ?>