Müteahhitlik
Hizmetlerimiz
$hizmetler_page_q = "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_ID = '0' AND PAGE.CAT_PAGE = '0' ORDER BY PAGE.SORTBY ASC";
$hizmetler_page = $db->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.'';
}
}
?>
Bize Ulaşın
Muratçeşme Mh. Sultan Murat Cd. No:41/C Muratçeşme - Büyükçekece / İstanbul