Ответ в теме: Скрыть ссылки "пустых" категорий

[sarkis]

так вы делайте запрос в контроллере (пример)

$db_query="select * from ".DB_PREF."advert advert " ." where " //." advert.n_category IN (".$this->list_id_inferiorcategory(false,true).") " .( $t_db_query_category ? " ( ".$t_db_query_category." ) and " : "" ) ." advert.hide='show' " ." and advert.end_putdate > ".$GLOBALS["timeDayAdvert"]." " .$db_query_stext.$db_query_cost .$this->add_db_query_country().$this->add_db_query_region().$this->add_db_query_city() ." order by " .( $this->name_sort ? " ".$init_sort_doska[$this->name_sort]." ".$this->type_sort." " : " premium_adv DESC, sort_time DESC ") ." limit ".($this->open_num_page_all_advert-1)*KOL_ADVERT_TO_ALL_PAGE." , ".KOL_ADVERT_TO_ALL_PAGE; list($kolvo,$this->data_all_advert)=obr_db_query_select_assoc($db_query);

1 2 3 4 5 6 7 8 9 10 11 12 13

$db_query="select *        from ".DB_PREF."advert advert  "        ." where "        //." advert.n_category IN (".$this->list_id_inferiorcategory(false,true).") "        .( $t_db_query_category ? " ( ".$t_db_query_category." ) and " : "" )        ." advert.hide='show' "        ." and advert.end_putdate > ".$GLOBALS["timeDayAdvert"]."   "        .$db_query_stext.$db_query_cost        .$this->add_db_query_country().$this->add_db_query_region().$this->add_db_query_city()        ." order by "        .( $this->name_sort ? " ".$init_sort_doska[$this->name_sort]." ".$this->type_sort." " :  " premium_adv DESC, sort_time DESC ")        ." limit ".($this->open_num_page_all_advert-1)*KOL_ADVERT_TO_ALL_PAGE." , ".KOL_ADVERT_TO_ALL_PAGE;     list($kolvo,$this->data_all_advert)=obr_db_query_select_assoc($db_query);

а потом результат передавайте в шаблон, а там уже циклом разбирайте