Как организовать систему вывода из БД ?

    $tpl->load_template( 'calendar/next.tpl' );
    $sql_date = $db->query("SELECT s.*, e.* FROM " . PREFIX . "_post s LEFT JOIN " . PREFIX . "_episode e ON (e.show_id=s.id) WHERE TO_DAYS(NOW()) - TO_DAYS(epdate) <= 0 ORDER BY epdate ASC");
    while ( $row_d = $db->get_row($sql_date) ) {
        $tpl->set( '{epdate}', NewTime($row_d['epdate']) );
            $sql_episode = $db->query("SELECT s.*, e.* FROM " . PREFIX . "_post s," . PREFIX . "_episode e WHERE e.show_id = s.id AND e.epdate = '{$row_d['epdate']}'");
                while( $row_e = $db->get_row($sql_episode)) {
                    $full_link = $config['http_home_url'] . get_url( $row_e['category'] ) . "/" . $row_e['id'] . "-" . $row_e['alt_name'] . ".html";
                    $episode .= "<div class=\"episode\"><div class=\"episodes-image\">
                    <a href=\"".$full_link."\">
                    <img src=\"" . $config['http_home_url'] . "uploads/posts/" . $row_e['poster'] . "\" width=\"100%\"></a></div>
                    <div class=\"epdesc\">
                    <div class=\"shrutitle\"><a href=\"".$full_link."\">" . $row_e['title'] . "</a></div>
                    <!--div class=\"shtitle\">Marvels Agents of S.H.I.E.L.D.</div-->
                    <div class=\"eptitle\"><b>".$row_e['season_id']. "x".$row_e['nomer']. "</b>  ".$row_e['eptitle']. "</div>
                    </div></div>";
                    $i++;
                }
        if($episode) {
        $tpl->set( '[next]', "" );
        $tpl->set( '[/next]', "" );
        $tpl->set( '{next}', $episode );
        } else {
        $tpl->set_block( "'\\[next\\](.*?)\\[/next\\]'si", "" );
        $tpl->set( '{next}', '' );
        }
        $episode = null;
    $tpl->compile('content');
    }
    $db->free();

 Показать / Скрыть текст