"A","2" => "B","3" => "C","4" => "D","5" => "E","6" => "F","7" => "G","8" => "H","9" => "I","10" => "J","11" => "K","12" => "L","13" => "M","14" => "N","15" => "O","16" => "P","17" => "Q","18" => "R","19" => "S","20" => "T","21" => "U","22" => "V","23" => "W","24" => "X","25" => "Y","26" => "Z","27" => "가","28" => "나","29" => "다","30" => "라","31" => "마","32" => "바","33" => "사","34" => "아","35" => "자","36" => "차","37" => "카","38" => "타","39" => "파","40" => "하","41" => "0"); $qrystring = "&category=".$category. "&searchkey=".$searchkey. "&apno=".$apno; $PageSize = 8; if( empty( $PageNo ) ) $PageNo = 1; if( empty( $apno ) ) $apno = 1; $START = $objfunc->getDbStartNo( $PageNo, $PageSize ); ?>
= binary('".$startStr."') AND name < binary('".$endStr."') ) OR ( name >= binary('".strtolower($startStr)."') AND name < binary('".strtolower($endStr)."') ) )"; }else{ $whereqry .= " AND name >= binary('".$startStr."') AND name < binary('".$endStr."') "; } } $total = $objdb->sqlNumRows("SELECT name FROM brand WHERE 1=1 ".$whereqry." GROUP BY name"); if($_GET[searchkey]) $addOrderBy = "binary(name), "; $sql = "SELECT name, image, content, category FROM brand where 1=1".$whereqry." GROUP BY name ORDER BY ".$addOrderBy."category, sortno LIMIT ".$START.", ".$PageSize; $brandCateArr = $objdb->sqlArray($sql); $thisPageTotal = count($brandCateArr); for($i=0;$i<$thisPageTotal;$i = $i+2){ ?>
>
hancut($brandCateArr[$cnt][content], '30'), 'n')?>
'' ".$gwhereqry." ORDER BY wdate DESC LIMIT 2"; $result = $objdb->sqlResult($sql); $cnt=0; while($row=$objdb->sqlFetch($result)){ ?>
hancut($row[name], 17)?>
등록된 브랜드가 없습니다.
adminpaging( $PageNo, $PageSize, $total, "", $qrystring ); ?>