= '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'];
?>
|
0 || $lightning_count > 0) {
echo '프로모션';
}
?>
|
|
|
게시물이 없습니다. | '; } ?>
