영카트 주문내역리스트에 회원 닉네임 검색을 추가하고싶습니다. 채택완료

</p><p><?php</p><p>$sub_menu = '400400';</p><p>include_once('./_common.php');</p><p> </p><p>auth_check($auth[$sub_menu], "r");</p><p> </p><p>$g5['title'] = '주문내역';</p><p>include_once (G5_ADMIN_PATH.'/admin.head.php');</p><p>include_once(G5_PLUGIN_PATH.'/jquery-ui/datepicker.php');</p><p> </p><p>$where = array();</p><p> </p><p>$sql_search = "";</p><p>if ($search != "") {</p><p>    if ($sel_field != "") {</p><p>      if ($sel_field == 'mb_nick'){</p><p>        $res = sql_fetch(<span style="font-size: 14.6667px;">"select mb_id from {$g5['member_table']} where mb_nick like '%".$search."%'"</span>);</p><p>        $where[] = " mb_id = '{$res['mb_id']}' ";</p><p>      }else{</p><p>        $where[] = " $sel_field like '%$search%' ";</p><p>      }</p><p>    }</p><p> </p><p>    if ($save_search != $search) {</p><p>        $page = 1;</p><p>    }</p><p>}</p><p> </p><p>//이하 생략...</p><p>

</p><p><label for="sel_field" class="sound_only">검색대상</label></p><p><select name="sel_field" id="sel_field"></p><p>    <option value="od_id" <?php echo get_selected($sel_field, 'od_id'); ?>>주문번호</option></p><p>    <option value="mb_id" <?php echo get_selected($sel_field, 'mb_id'); ?>>회원 ID</option></p><p>    <option value="od_name" <?php echo get_selected($sel_field, 'od_name'); ?>>주문자</option></p><p>    <option value="mb_nick" <?php echo get_selected($sel_field, 'mb_nick'); ?>>닉네임</option></p><p>    <option value="od_tel" <?php echo get_selected($sel_field, 'od_tel'); ?>>주문자전화</option></p><p>    <option value="od_hp" <?php echo get_selected($sel_field, 'od_hp'); ?>>주문자핸드폰</option></p><p>    <option value="od_b_name" <?php echo get_selected($sel_field, 'od_b_name'); ?>>받는분</option></p><p>    <option value="od_b_tel" <?php echo get_selected($sel_field, 'od_b_tel'); ?>>받는분전화</option></p><p>    <option value="od_b_hp" <?php echo get_selected($sel_field, 'od_b_hp'); ?>>받는분핸드폰</option></p><p>    <option value="od_deposit_name" <?php echo get_selected($sel_field, 'od_deposit_name'); ?>>입금자</option></p><p>    <option value="od_invoice" <?php echo get_selected($sel_field, 'od_invoice'); ?>>운송장번호</option></p><p></select></p><p>/* 이하 생략 */</p><p>