catalog.php
596 Bytes
<?php
$res = $setup->db->getAll("select p.*,r.translit as rubric_translit from catalogs_products p LEFT JOIN catalogs_rubrics r ON r.id=p.rubric_id where p.count_modifications>0 and p.rubric_id=? order by p.mktime desc",array($_GET['catID']),DB_FETCHMODE_ASSOC);
$setup->tpl->assign('products',$res);
$rubric = $setup->db->getOne("select name from catalogs_rubrics where id=?",array($_GET['catID']));
$setup->meta = array("title"=>$rubric . " - Êàðòà ñàéòà ExstremStyle.ua","keywords"=>"","description"=>$rubric . " Êëþ÷åâûå ñòðàíèöû ñàéòà");
$setup->tpl->assign('tpl',"sitemap-catalog.tpl");
?>