$site_path = "../HyAdmin/"; require_once($site_path."include/lib.inc.php"); $ss_mb_idChk = $_SESSION['ss_mb_id']; if(!$ss_mb_idChk) hy_href("/HyAdmin/mb_login.php","·Î±×ÀÎÈÄÀÌ¿ëÇØÁÖ¼¼¿ä."); if($ss_mb_idChk){ //ȸ¿øÀ̶ó¸é $queryM = "select * from hy_member where mb_id='$ss_mb_idChk'"; $rsM = query($queryM,$dbcon); $rowM = mysql_fetch_array($rsM); $mb_idChk = $rowM[mb_id]; } $goodsTable = "hy_apply"; //if(!$CatNo) $CatNo = 1; //±¸ºÐ $str_que = " and ReMemId = '$mb_idChk'"; if($searTex){ if($searWh == "1"){ $str_que .= " and (ReMemName like '%$searTex%' or ReCatTitle like '%$searTex%' or ReTrackTitle like '%$searTex%')"; }elseif($searWh == "2"){ $str_que .= " and ReMemName like '%$searTex%'"; }elseif($searWh == "3"){ $str_que .= " and ReCatTitle like '%$searTex%'"; }elseif($searWh == "4"){ $str_que .= " and ReTrackTitle like '%$searTex%'"; } } //ÃÑ»óǰ°¹¼ö $count_que = "select * from $goodsTable where (1=1) $str_que"; $count_list = query($count_que,$dbcon); $count_total = mysql_num_rows($count_list); if(!$scale){ $scale = "10"; //¸®½ºÆ®¼ö } $pagescale = "10"; //ÆäÀÌÁö¼ö if(!$start) $start=0; //½ÃÀÛÆäÀÌÁö $current = ceil(($start+1)/$scale); //ÇöÀç $list_que = "select * from $goodsTable where (1=1) $str_que order by ReOrder DESC,ReIdx DESC limit $start,$scale"; $result_list = query($list_que,$dbcon); $total = mysql_num_rows($result_list); ?>
ÁÖ¹®³¯Â¥ | ÀԱݻóÅ | ºÐ·ù | Æ®·¢ | ¼ºñ½º | ´äº¯ | ÁøÇà»óÅ | ÀÛ¾÷»óÅ | |
---|---|---|---|---|---|---|---|---|
=$ReInDateArr[0]?>.=$ReInDateArr[1]?>.=$ReInDateArr[2]?> | =$ReInputTit?> | =$ReCatKeyTit?> | =$ReTrackTit?> | =$ReViewSel?> | ´äº¯Àü | }else{?>´äº¯¿Ï·á¡å | }?>}elseif($row[ReState]=="Y"){?> }?> |
ÀÛ¾÷´ë±â
}elseif($row[ReWork]=="G"){?>
ÀÛ¾÷Áß
}elseif($row[ReWork]=="Y"){?>
}?>
}?>
|
=nl2br($row[ReMemo])?> °ßÀû±Ý¾× : =number_format($row[RePrice])?>¿ø |
¿¡ÇÇÅäÇÇ |