Просмотр архива Mobtops


<?


      DEFINE('TITLE' , 'Категории');  # фиксируем титул

      head();



      $site_category = $db -> query
                            ("

                             SELECT * FROM `site_category` ORDER BY `name` ASC

                            ");

        if($site_category -> rowCount() > 0)
        {
            while($sc = $site_category -> fetch(PDO::FETCH_ASSOC))

            {

             $siteActive = $db -> query
                            ("

                             SELECT * FROM site,site_statistic WHERE site.status = '1'   and  site.id = site_statistic.siteID
                             and  site_statistic.date = '".date("Y-m-d",time())."'
                             and `host` > '0' and site.category = '".$sc['id']."'

                            ");

            $site = $db -> query
                            ("

                             SELECT * FROM `site` WHERE `category` = '".$sc['id']."'

                            ");

             echo '<div class = "main"><img src="/desing/images/chart_line_link.png" alt="&#xbb;" /> '.url('/sitelist/'.$sc['id'].'/',''.$sc['name'].'','','').'
             ['.$siteActive -> rowCount().'/'.$site -> rowCount().']</div>';

            }

        }

          else

        {

          echo '<div class="main">Категорий нет</div>';

        }



      foot();


?>