Rosa Yapı
Devam Eden Projelerimiz
$projeler_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,PAGE.CAT_ID,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 = '3' AND PAGE.STATUS = '1' AND PAGE.CAT_ID = '4' AND PAGE.CAT_PAGE = '0' ORDER BY PAGE.SORTBY ASC";
$projeler = $db->loadObjectList($projeler_q);
if($projeler)
{
foreach ($projeler as $key => $value) {
$image_q = "SELECT URL FROM IMAGES WHERE UNIQ_ID = '{$value->PAGE_UNIQ}' AND LANG_ID = '{$value->LANG_ID}' AND MAIN = '1'";
$image = $db->loadObject($image_q);
if($image)
{
$url = $image->URL;
}
else
{
unset($url);
}
echo '
';
}
}
?>