sqlArray( $sql, "level" ); $sql = "SELECT * FROM $TBLBC ". "WHERE bbsid = '".$bbs."' ". "ORDER BY sortno"; $dataCate = $objdb->sqlArray( $sql ); foreach( $dataCate as $k => $data ) { $nameCate[$data[cate_idx]] = $data[cate_name]; } unset( $QRY ); if( $_REQUEST[keyword] ) { $QRY[] = $_REQUEST[sl_search]." LIKE '%".$_REQUEST[keyword]."%'"; } $WHEREQRY = ""; if( count( $QRY ) ) $WHEREQRY = "AND ".implode( " AND ", $QRY ); unset( $QRY ); if( $_REQUEST[srch_cate_idx] != "" ) { $QRY[] = "cate_idx = '".$_REQUEST[srch_cate_idx]."'"; } $CATEQRY = ""; if( count( $QRY ) ) $CATEQRY = "AND ".implode( " AND ", $QRY ); $sql = "SELECT COUNT( * ) FROM $TBLB ". "WHERE bbsid = '".$bbs."' $WHEREQRY $CATEQRY"; $totalRows = $objdb->sqlRowOne( $sql ); if( empty( $_REQUEST["PageNo"] ) ) $PageNo = 1; else $PageNo = $_REQUEST["PageNo"]; $PageSize = 20; $START = $objfunc->getDbStartNo( $PageNo, $PageSize ); $pointAct = unserialize( stripslashes( $_POINTACT ) ); $newdate = date( "Y-m-d H:i:s", mktime( date( 'H' ) - $dbnewperiod, date( 'i' ), date( 's' ), date( 'm' ), date( 'd' ), date( 'Y' ) ) ); ?>
sqlResult($sql); $i = 1; while( $row = $objdb->sqlFetch($rs) ){ $btnImg1 = "btnst1"; $btnImg2 = "btnst7"; if( $i == 5 ){ $btnImg1 = "btnst2"; $btnImg2 = "btnst8"; } if( $i == 6 ){ $btnImg1 = "btnst3"; $btnImg2 = "btnst9"; } ?>
sqlArray( $sql ); if($totalRows){ ?>
등록된 상품이 없습니다.