날짜 검색 질문드립니다. (다시질문.ㅠ) 채택완료

</p>

<p>if ($is_search_bbs) {

    $sql = " select distinct wr_parent from {$write_table} where {$sql_search} {$sql_order} limit {$from_record}, $page_rows ";

} else {

    $sql = " select * from {$write_table} where wr_is_comment = 0 ";

    if(!empty($notice_array))

        $sql .= " and wr_id not in (".implode(', ', $notice_array).") ";

    $sql .= " {$sql_order} limit {$from_record}, $page_rows ";

}</p>

<p>

</p>

<p>// ------------------------------------------- 추가</p>

<p>$sql_datet = '';

if ($s_Date && $e_Date) {

    $sql_datet .= " and left(wr_datetime, 10) between '{$s_Date}' and '{$e_Date}' ";

}   </p>

<p>// ------------------------------------------- 추가</p>

<p>if ($sca || $stx || $stx === '0') {     //검색이면

    $is_search_bbs = true;      //검색구분변수 true 지정

    $sql_search = get_sql_search($sca, $sfl, $stx, $sop);</p>

<p>    // 가장 작은 번호를 얻어서 변수에 저장 (하단의 페이징에서 사용)

    $sql = " select MIN(wr_num) as min_wr_num from {$write_table} ";

    $row = sql_fetch($sql);

    $min_spt = (int)$row['min_wr_num'];</p>

<p>    if (!$spt) $spt = $min_spt;</p>

<p>    //$sql_search .= " and (wr_num between {$spt} and ({$spt} + {$config['cf_search_part']})) "</p>

<p>    $sql_search .= " and (wr_num between {$spt} and ({$spt} + {$config['cf_search_part']})) {$sql_datet} ";

    

    // 원글만 얻는다. (코멘트의 내용도 검색하기 위함)

    // 라엘님 제안 코드로 대체 <a href="http://sir.kr/g5_bug/2922" target="_blank" rel="noopener noreferrer">http://sir.kr/g5_bug/2922</a>

    $sql = " SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} WHERE {$sql_search} ";

    $row = sql_fetch($sql);

    $total_count = $row['cnt'];

    /*  

    $sql = " select distinct wr_parent from {$write_table} where {$sql_search} ";

    $result = sql_query($sql);

    $total_count = sql_num_rows($result);

    */

} else {

    $sql_search = "";</p>

<p>    $total_count = $board['bo_count_write'];

}</p>

<p>

</p>

<p>        <form name="fsearch" method="get">

            <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">

            <label for="sfl" class="sound_only">검색대상</label>

            <select name="sfl" id="sfl">

                <?php echo get_board_sfl_select_options($sfl); ?>

            </select></p>

<p>            <!-- <input type="hidden" name="sfl" value="wr_datetime"<?php // echo get_selected($sfl, 'wr_datetime'); ?>> --></p>

<p>            <input type="text" name="s_Date" id="s_Date" autocomplete="off">~<input type="text" name="e_Date" id="e_Date" autocomplete="off"></p>

<p>            ...</p>

<p>        </form></p>

<p>

</p>

<p>    $sql = " SELECT COUNT(DISTINCT `wr_parent`) AS `cnt` FROM {$write_table} WHERE {$sql_search} {$sql_datet}";</p>

<p>    $row = sql_fetch($sql);</p>

<p>    $total_count = $row['cnt'];</p>

<p>