queryDBArray($select); $TPL -> assign("productArray", $rowArray); // regiony $select = " SELECT DISTINCT r.id, r.name FROM region r WHERE r.language_id = '".$_SESSION['lang']."' ORDER BY r.language_id, r.ord DESC "; $rowArray = $dbMysql -> queryDBArray($select); $TPL -> assign("regionArray", $rowArray); // regiony $q = " SELECT c.id, c.title, c.content1, c.content2, c.region_id FROM contact c INNER JOIN region r ON r.id = c.region_id AND r.language_id = '".$_SESSION['lang']."' ORDER BY c.ord DESC"; $TPL -> assign("contactArray", $dbMysql -> queryDBArray($q)); $TPL -> display($module.'/content.tpl'); ?>