include "config.inc.php"; session_start(); if (!isset($_SESSION["interface_lang"]) || $_SESSION["interface_lang"]=="") $_SESSION["interface_lang"]="GR"; //$_GET["poli_id"] = 1; $interface_quer = mysql_query ("select * from ".$db_prefix."interface_general where lang = '$interface_lang'") or die(mysql_error()); $lang = mysql_fetch_array($interface_quer); $title_search = stripslashes($lang['title_search']); $query_par = "SELECT count(id) AS count FROM ".$db_prefix."themata WHERE menu = 'right'"; $result_par = mysql_query($query_par); $row = mysql_fetch_array($result_par); $count0 = $row[0]; $polis_query = mysql_query("select * from ".$db_prefix."nav_polis where id=".$_GET["poli_id"]) or die(mysql_error()); $polis = mysql_fetch_array($polis_query); $id = $polis['id']; $poli_order = $polis['poli_ord']; $poli_name["GR"] = $polis['poli_name_GR']; $poli_name["EN"] = $polis['poli_name_EN']; $poli_name["DE"] = $polis['poli_name_DE']; $peri_id_p = $polis['peri_id']; // naydem imya perif $peri_query = mysql_query("select peri_id, peri_name_".$_SESSION["interface_lang"]." as peri_name from ".$db_prefix."nav_perif where peri_id=".$peri_id_p) or die(mysql_error()); $peri_q = mysql_fetch_array($peri_query); $perif_name = $peri_q['peri_name']; $nomo_id_p = $polis['nomo_id']; // naydem imya nomos $nomo_query = mysql_query("select nomo_id, nomo_name_".$_SESSION["interface_lang"]." as nomo_name from ".$db_prefix."nav_nomos where nomo_id=".$nomo_id_p) or die(mysql_error()); $nomo_q = mysql_fetch_array($nomo_query); $nomos_name = $nomo_q['nomo_name']; $poli_image_0 = $polis['poli_image_0']; $poli_image_1 = $polis['poli_image_1']; $poli_image_2 = $polis['poli_image_2']; $poli_image_3 = $polis['poli_image_3']; $poli_image_4 = $polis['poli_image_4']; // fields from left menu $thema_query = mysql_query("select * from ".$db_prefix."themata where menu = 'left' order by cat_order") or die(mysql_error()); $i=1; while ($thema_q = mysql_fetch_array($thema_query)){ $thema_name = $thema_q['thema_name']; $thema_name_GR = $thema_q['thema_name']."_GR"; $thema_name_EN = $thema_q['thema_name']."_EN"; $thema_name_DE = $thema_q['thema_name']."_DE"; //2.nayti ego znachenie v tablicu goroda $polis_query = mysql_query("select $thema_name_GR AS left_GR, $thema_name_EN AS left_EN, $thema_name_DE AS left_DE from ".$db_prefix."nav_polis where id=".$_GET['poli_id']) or die(mysql_error()); $polis = mysql_fetch_array($polis_query); $left["GR"][$i] = $polis['left_GR']; $left["EN"][$i] = $polis['left_EN']; $left["DE"][$i] = $polis['left_DE']; //echo $sql_dop; exit; $i++; }?>
|