bbs/admin/memberlist.php파일에서요
<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "STYLE");

include "./bbs/admin/admin.lib.php";
include "./bbs/gblayer.php";

$menu = "menu020";

$sql_common = " from $cfg[table_member] ";

$sql_search = " where (1) ";
if ($stext) {
$sql_search .= " and ( ";
switch ($sselect) {
case "mb_level" :
case "mb_point" :
$sql_search .= " ($sselect >= '$stext') ";
break;
default :
$sql_search .= " ($sselect like '%$stext%') ";
break;
}
$sql_search .= " ) ";
}
?>
위에서요
$sql_search = " where (1) ";
if ($stext) {
$sql_search .= " and ( ";
switch ($sselect) {
case "mb_level" :
case "mb_point" :
$sql_search .= " ($sselect >= '$stext') ";
break;
default :
$sql_search .= " ($sselect like '%$stext%') ";
break;
}
$sql_search .= " ) ";
부분이 머를 뜻하는가요..?
그리고요. 위에서 등급5인 것만 쿼리문으로 날릴라 카는데요..
where mb_level=5 이렇게 하면되나요..?