Müteahhitlik

loadObjectList($hizmetler_page_q); if($hizmetler_page) { foreach ($hizmetler_page as $key => $value) { echo ''.$value->PAGE_LINK.''; } } $hizmetler_page_q2 = "SELECT PAGE_DESC.PAGE_LINK, PAGE_DESC.PAGE_SHORT_DESC, PAGE.PAGE_UNIQ, PAGE_DESC.LANG_ID, PAGE_DESC.SEO_LINK AS P_SEO_LINK, PAGE_CAT_DESC.SEO_LINK AS C_SEO_LINK FROM PAGE_DESC INNER JOIN PAGE ON PAGE.PAGE_UNIQ = PAGE_DESC.PAGE_UNIQ INNER JOIN PAGE_CAT ON PAGE_CAT.PAGE_CAT_ID = PAGE.CAT_ID INNER JOIN PAGE_CAT_DESC ON PAGE_CAT_DESC.PAGE_CAT_UNIQ = PAGE_CAT.PAGE_CAT_UNIQ WHERE PAGE_DESC.LANG_ID = '{$GLOBALS["lid"]}' AND PAGE.MODUL_ID = '2' AND PAGE.STATUS = '1' AND PAGE.CAT_ID > '0' AND PAGE.CAT_PAGE = '0'"; $hizmetler_page2 = $db->loadObjectList($hizmetler_page_q2); if($hizmetler_page2) { foreach ($hizmetler_page2 as $key2 => $value2) { echo ''.$value2->PAGE_LINK.''; } } $hizmetler_page_q1 = "SELECT PAGE_DESC.SEO_LINK,PAGE_DESC.PAGE_LINK,PAGE_DESC.PAGE_TITLE,PAGE_DESC.PAGE_SHORT_DESC,PAGE_DESC.PAGE_UNIQ,PAGE_DESC.LANG_ID FROM PAGE_DESC INNER JOIN PAGE ON PAGE.PAGE_UNIQ = PAGE_DESC.PAGE_UNIQ WHERE PAGE_DESC.LANG_ID = '{$GLOBALS["lid"]}' AND PAGE.MODUL_ID = '2' AND PAGE.STATUS = '1' AND PAGE.CAT_PAGE = '1' ORDER BY PAGE.SORTBY ASC"; $hizmetler_page1 = $db->loadObjectList($hizmetler_page_q1); if($hizmetler_page1) { foreach ($hizmetler_page1 as $key1 => $value1) { echo ''.$value1->PAGE_LINK.''; } } ?>