회원검색 조건문 관련 채택완료
xxbobo
11년 전
조회 5,365
회원검색에서
$sql_common = " from $g4[member_table] ";
$qstr = "";
if (isset($Usex)) $qstr .= '&Usex=' . urlencode($Usex);
if (isset($UageF)) $qstr .= '&UageF=' . urlencode($UageF);
if (isset($UageT)) $qstr .= '&UageT=' . urlencode($UageT);
if (isset($Uid)) $qstr .= '&Uid=' . urlencode($Uid);
if (isset($UregF)) $qstr .= '&UregF=' . urlencode($UregF);
if (isset($UregT)) $qstr .= '&UregT=' . urlencode($UregT);
if (isset($Uid3)) $qstr .= '&Uid3=' . urlencode($Uid3);
if (isset($Uid6)) $qstr .= '&Uid6=' . urlencode($Uid6);
$sql_search = " where (1) ";
if ($Usex) { $sql_search .= " and (mb_sex = '$Usex') "; }
if ($UageF) { $sql_search .= " and (mb_birth <= '$UageF') "; }
if ($UageT) { $sql_search .= " and (mb_birth >= '$UageT') "; }
if ($Uid3) { $sql_search .= " and (mb_3 = '$Uid3') "; }
if ($Uid6) { $sql_search .= " and (mb_6 = '$Uid6') "; }
if ($Uid) { $sql_search .= " and (mb_nick like '%$Uid%') "; }
if ($UregF) { $sql_search .= " and (mb_2 = '$UregF') "; }
if ($UregT) { $sql_search .= " and (mb_datetime <= '$UregT') "; }
if (!$sst) {
$sst = "mb_today_login";
$sod = "desc";
}
최근에 접속한 순서로 나타나게 되는데요~ 여기에 mb_1 의 값이 1인 회원들만 나타나게 하려면 어찌해야하나요...
즉 최근 접속한 순으로 mb_1 의 값이 1인 회원만 ...
어렵네요 ㅜㅜ
댓글을 작성하려면 로그인이 필요합니다.
답변 2개
채택된 답변
+20 포인트
11년 전
$sql_common = " from $g4[member_table] ";</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">
</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">$qstr = "";</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($Usex)) $qstr .= '&Usex=' . urlencode($Usex);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($UageF)) $qstr .= '&UageF=' . urlencode($UageF);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($UageT)) $qstr .= '&UageT=' . urlencode($UageT);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($Uid)) $qstr .= '&Uid=' . urlencode($Uid);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($UregF)) $qstr .= '&UregF=' . urlencode($UregF);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($UregT)) $qstr .= '&UregT=' . urlencode($UregT);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($Uid3)) $qstr .= '&Uid3=' . urlencode($Uid3);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (isset($Uid6)) $qstr .= '&Uid6=' . urlencode($Uid6);</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">
</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">
</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">$sql_search = " where (1) ";</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">
</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($Usex) { $sql_search .= " and (mb_sex = '$Usex') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($UageF) { $sql_search .= " and (mb_birth <= '$UageF') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($UageT) { $sql_search .= " and (mb_birth >= '$UageT') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($Uid3) { $sql_search .= " and (mb_3 = '$Uid3') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($Uid6) { $sql_search .= " and (mb_6 = '$Uid6') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($Uid) { $sql_search .= " and (mb_nick like '%$Uid%') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($UregF) { $sql_search .= " and (mb_2 = '$UregF') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if ($UregT) { $sql_search .= " and (mb_datetime <= '$UregT') "; }</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px"><b>$sql_search .= " and (mb_1 = '1') "; // 추가</b></div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">
</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">if (!$sst) {</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px"> $sst = "mb_today_login";</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px"> $sod = "desc";</div>
<div style="font-family: gulim, helvetica; line-height: 23.54400062561035px">}요로코롬 하면 되지 않을까요?
로그인 후 평가할 수 있습니다
댓글을 작성하려면 로그인이 필요합니다.
답변을 작성하려면 로그인이 필요합니다.
로그인