Specific mysql record listing

        <section class="latest-news-index">
    <table style="width: 100%; max-width: 100%;margin-bottom: 20px; "class="table table-hover ">
            <tbody><tr><td style="border-bottom: 1px solid #9e9e9e;border-top: none;font-size: 2.1em;font-weight: bold;" colspan="99" class="date-header"><?php echo date('m.d.y');?></td></tr>
            <?php
            $sayfa = $news->pager($SAYFA,15,'haber','h_id',"WHERE onay='1' AND time<='".time()."'");
            $sql = $db->sql(
    "SELECT haber.h_id, 
            haber.k_id, 
            haber.baslik, 
            haber.baslik_renk, 
            haber.resim, 
            haber.k_icerik, 
            haber.link, 
            haber.time, 
            kategori.baslik as kategori 
    FROM haber 
    LEFT JOIN kategori ON haber.k_id=kategori.k_id
    WHERE kategori.onay='1' 
      AND haber.onay='1' 
      AND DATE(FROM_UNIXTIME(haber.time)) = DATE(SYSDATE())
    ORDER BY haber.time DESC 
    "
);
            if($db->num_rows($sql)>0):
                $i = 1;
                while($data = $db->f_array($sql)):
                    $id     = $news->dataview($data['h_id']);
                    $baslik = $news->dataview($data['baslik']);
                    $baslik_renk= ($news->dataview($data['baslik_renk']) ? ' style="color:'.$news->dataview($data['baslik_renk']).';"' : '');
                    $resim      = $news->dataview($data['resim']);
                    $kIcerik    = $news->dataview($data['k_icerik']);
                    $time   = $news->dataview($data['time']);
                    $kategori = $news->dataview($data['kategori']);
                    $haberlink  = $news->dataview($data['link']);
                    $link = ($haberlink == '' ? $news->url('haber',$id,$baslik) : $haberlink);
        ?>
                <tr style="padding: 8px;font-size: 15px;line-height: 1.42857143;vertical-align: top;">
                <?php if($sistem['iceriktarih']): ?>
            <td style="padding: 8px;font-size: 15px;line-height: 1.42857143;color: red;vertical-align: top;border-top: 1px solid #ddd;"><?=$news->saat($time)?></td>
            <?php endif; ?>
            <td style="padding: 8px;font-size: 15px;line-height: 1.42857143;color:#black;vertical-align: top;border-top: 1px solid #ddd;"><?=$kategori?> </td>
            <td style="padding: 8px;font-size: 20px;line-height: 1.42857143;vertical-align: top;border-top: 1px solid #ddd;"><b><a style="color: #0f3f5e;" href="<?=$link?>"><?=$baslik?><span class="title-icons"></span></a></b></td>
        </tr>
        <?php
                endwhile;
            endif;
        ?>            
    </tbody></table>
</section>

Hello friends, My system has: video, photo, "breaking news"

This is how my system should work:

If news has video it should have video Icon.

If news has photo gallery it should have photo icon.

Can someone help me with this?

Thanks in advance.