새글아이콘 쿼리문좀 봐주세요 채택완료

<?php
$sql = " 
  select wr_1 
    from g5_write_game 
   where wr_is_comment = '0' 
     and wr_ 1 in ('원신', '몬스터헌터', '에픽세븐', '라그나로크', '바이오하자드', 'LOL')    
     and wr_datetime > now() - interval 12 hour  
   order by wr_datetime desc 
   limit 100
";

$result = sql_query($sql);

while ($row = sql_fetch_array($result)) {
    if ($row['wr_1'] == '원신')
        $new_1 = true;
    else if ($row['wr_1'] == '몬스터헌터')
        $new_2 = true;
    else if ($row['wr_1'] == '에픽세븐')
        $new_3 = true;
    else if ($row['wr_1'] == '라그나로크')
        $new_4 = true;
    else if ($row['wr_1'] == '바이오하자드')
        $new_5 = true;
    else if ($row['wr_1'] == 'LOL')
        $new_6 = true;    
}
?>
<div class="game">

<ul>


<li class="half">
            <a href="<?php echo G5_BBS_URL;?>/board.php?bo_table=game">원신</a>
                <?php if($new_1) { ?>
                    <img src="/skin/board/game/img/icon_new.gif">
                <?php } ?>
            </a>
        </li>

<li class="half">
            <a href="<?php echo G5_BBS_URL;?>/board.php?bo_table=game">몬스터헌터</a>
                <?php if($new_2) { ?>
                    <img src="/skin/board/game/img/icon_new.gif">
                <?php } ?>
            </a>
        </li>

<li class="half">
            <a href="<?php echo G5_BBS_URL;?>/board.php?bo_table=game">에픽세븐</a>
                <?php if($new_3) { ?>
                    <img src="/skin/board/game/img/icon_new.gif">
                <?php } ?>
            </a>
        </li>

<li class="half">
            <a href="<?php echo G5_BBS_URL;?>/board.php?bo_table=game">라그나로크</a>
                <?php if($new_4) { ?>
                    <img src="/skin/board/game/img/icon_new.gif">
                <?php } ?>
            </a>
        </li>

<li class="half">
            <a href="<?php echo G5_BBS_URL;?>/board.php?bo_table=game">바이오하자드</a>
                <?php if($new_5) { ?>
                    <img src="/skin/board/game/img/icon_new.gif">
                <?php } ?>
            </a>
        </li>

<li class="half">
            <a href="<?php echo G5_BBS_URL;?>/board.php?bo_table=game">LOL</a>
                <?php if($new_6) { ?>
                    <img src="/skin/board/game/img/icon_new.gif">
                <?php } ?>
            </a>
        </li>

</ul>

</div>