필드 숫자 범위 검색...도와주세요.ㅠㅠ
본문
>선택 필드 숫자 예를들면 1~5 까지 범위 검색을 할려고 하는데 생각대로 잘 안되네요.ㅠㅠ....
>
> 도와 주세요~~
> 어떤 부분을 수정을 해야 하나요?
>
> <div class="bo_fx">
> <div id="bo_list_total">
> <span>Total <?php echo number_format($total_count) ?>건</span>
> <?php echo $page ?> 페이지
> <form name="fsearch" method="get" style="">
> <input type="hidden" name="bo_table" value="<?php echo $bo_table ?>">
>
> <input type="hidden" name="sca" value="<?php echo $sca ?>">
> <input type="hidden" name="sop" value="and">
> <input type="hidden" name="sfl" value="wr_subject||wr_content||wr_1||wr_2||wr_3||wr_4||wr_5||wr_6||wr_7||wr_8||wr_9||wr_10||wr_11||wr_12||wr_13||wr_14||wr_15||wr_16||wr_17||wr_18||19||20||21">
> <div style="margin:5px 0;">
> <input type="text" id="val_from" name="stx" value="<?php echo stripslashes($stx) ?>" class="frm_input" size="10" maxlength="10" placeholder="시작" > ~
> <input type="text" id="val_to" name="stx" value="<?php echo stripslashes($stx) ?>" class="frm_input" size="10" maxlength="10" placeholder="종료" >
>
>
>
> <select name="sfl" id="sfl">
> <option value="wr_subject||wr_1||wr_2||wr_3||wr_4||wr_5||wr_6||wr_7||wr_8||wr_9||wr_10||wr_11||wr_12||wr_13||wr_14||wr_15||wr_16||wr_17||wr_18||wr_19||wr_20||wr_21"<?php echo get_selected($sfl, 'wr_subject||wr_1||wr_2||wr_3||wr_4||wr_5||wr_6||wr_7||wr_8||wr_9||wr_10||wr_11||wr_12||wr_13||wr_14||wr_15||wr_16||wr_17||wr_18||wr_19||wr_20||wr_21'); ?>>전체검색</option>
> <option value="wr_6"<?php echo get_selected($sfl, 'wr_6'); ?>>호수</option>
> <option value="wr_7"<?php echo get_selected($sfl, 'wr_7'); ?>>전용면적</option>
> <option value="wr_8"<?php echo get_selected($sfl, 'wr_8'); ?>>분양면적</option>
> <option value="wr_9"<?php echo get_selected($sfl, 'wr_9'); ?>>평당가격</option>
> <option value="wr_10"<?php echo get_selected($sfl, 'wr_10'); ?>>분양가격</option>
> <option value="wr_11"<?php echo get_selected($sfl, 'wr_11'); ?>>총분양가</option>
> <option value="wr_12"<?php echo get_selected($sfl, 'wr_12'); ?>>프리미엄</option>
> <option value="wr_13"<?php echo get_selected($sfl, 'wr_13'); ?>>매매가격</option>
> <option value="wr_14"<?php echo get_selected($sfl, 'wr_14'); ?>>보증금</option>
> <option value="wr_15"<?php echo get_selected($sfl, 'wr_15'); ?>>월세</option>
> <option value="wr_16"<?php echo get_selected($sfl, 'wr_16'); ?>>임료</option>
>
> </select>
>
>
>
>
>
>
> </div>
> <div style="margin:5px 0;">
>
> <input type="submit" value="검색" class="btn_submit" style="padding:6px 7px 5px 7px;">
> >
답변 1
이건 bbs/list.php 자체를 수정해야합니다
예를들어 rating=1
즉 hidden name='rating' value='1' 로 넘긴다면
list.php에서
if ($sca || $stx) { -> if ($sca || $stx || $rating)
if($rating != '') $sql_search .= "and 필드 between 1 and 5";
이런식으로 해야하며 필드는 tinyint, int등 정수형이어야 합니다.