실시간검색어 관련 도와주시면 감사합니다. 채택완료

</p>

<p><!-- 실시간검색어-->

<?

$fr_date = date("Y-m-d");

$to_date = date("Y-m-d");

$sql_common = " from {$g5['popular_table']} a ";

$sql_search = " where trim(pp_word) <> '' and pp_date between '{$fr_date}' and '{$to_date}' ";

$sql_group = " group by pp_word ";

$sql = " select pp_word {$sql_common} {$sql_search} {$sql_group} ";

$result = sql_query($sql);

$total_count = sql_num_rows($result);

if($total_count<10){

    $fr_date = date("Y-m-d", strtotime("-3 day"));

    $to_date = date("Y-m-d");

    $sql_search = " where trim(pp_word) <> '' and pp_date between '{$fr_date}' and '{$to_date}' ";

}

$sql_order = " order by cnt desc ";

$sql = "select pp_word, count(*) as cnt {$sql_common} {$sql_search} {$sql_group} {$sql_order} limit 0, 10";

?>

<div class="search_list"><h3 class="tit">실시간검색어</h3>

        <div class="serch_now_list">

        <?php

        $result1 = sql_query($sql);

        for ($a=1; $row=sql_fetch_array($result1); $a++) {

            $word = get_text($row['pp_word']);

        ?>

        <a href="<?php echo G5_BBS_URL ?>/search.php?sfl=wr_subject&wr_content&sop=and&stx=<?php echo $word;?>"><em><?php echo $a;?></em> <?php echo $word;?></a>

        <?php } ?>

        </div>

        <span class="btn_view">∨</span>

</div>

<div class="serch_now_list_view">

        <ul>

        <?php 

        $result2 = sql_query($sql);

        for ($b=1; $row=sql_fetch_array($result2); $b++) {

            $word = get_text($row['pp_word']);

        ?>

        <li><a href="<?php echo G5_BBS_URL ?>/search.php?sfl=wr_subject&wr_content&sop=and&stx=<?php echo $word;?>"><em><?php echo $b;?></em> <?php echo $word;?></a></li>

        <?php } ?>

        </ul>

</div>

<div style="width:100%; height:10px;background-color: #e9ecf3;">

</div></p>

<p><script>

$(document).ready(function () {

    $('.btn_view').click(function(){

        var search_view = $(".serch_now_list_view");

        if( search_view.is(":visible") ){

            search_view.slideUp();

            $(this).html("∨");

        }else{

            search_view.slideDown();

            $(this).html("∧");

        }

    });</p>

<p>    function search_list(){

        $(".serch_now_list a:first").slideUp( function(){

            $(this).show();

            $(this).appendTo($(".serch_now_list")).slideDown();

        });

    }

    setInterval(function(){search_list()}, 3000);

});

</script></p>

<p>