دیتالایف انجین فارسی

$this_month = date( 'Y-m-d H:i:s', $_TIME );

    $tpl->load_template( 'topnews.tpl' );
    
    $db->query(  "SELECT id, short_story, title, date, alt_name, category, flag FROM " .  PREFIX . "_post WHERE approve=1 AND date >= '$this_month' - INTERVAL  1 MONTH AND date < '$this_month' ORDER BY rating DESC, comm_num  DESC, news_read DESC, date DESC LIMIT 0,10" );

$this_day = date( 'Y-m-d H:i:s', $_TIME );

    $tpl->load_template( 'topnews.tpl' );
    
    $db->query(  "SELECT id, short_story, title, date, alt_name, category, flag FROM " .  PREFIX . "_post WHERE approve=1 AND date >= '$this_day' - INTERVAL 3  DAY AND date < '$this_day' ORDER BY rating DESC, comm_num DESC,  news_read DESC, date DESC LIMIT 0,10" );