query("select title from in_tours where id = ".$_GET['id1']); $row_name = $db->fetch_array($res_name); $page['contacts_']['book'] = "Book for tour ".$row_name['title']; } else{ $res_name = $db->query("select title from hotels where id = ".$_GET['id1']); $row_name = $db->fetch_array($res_name); $page['contacts_']['book'] = "Book in at the hotel ".$row_name['title']; } } // Retrieve section data $result = $db->query("SELECT a.id, b.name, b.description FROM structure_in a, structure_names_in b WHERE a.item = '".$page['page']."' AND a.id = b.structure_id AND b.lang = $langID; "); if ($db->num_rows($result) > 0) { $row = $db->fetch_array($result); $page['section']['id'] = $row['id']; $page['section']['name'] = $row['name']; $page['section']['description'] = $row['description']; } // Retrieve information address $result = $db->query("SELECT a.*, b.item as item FROM structure_names_in a, structure_in b WHERE a.structure_id = b.id and a.lang = $langID AND a.structure_id = 246;"); // 216 is an id of 'about' section $row = $db->fetch_array($result); $page['main']['address']['description'] = $row['description']; $page['template'] = "contact.tpl"; ?> .:: SANJARBEK ::. Travel services in Uzbekistan, hotels and tickets booking, guides services, historical tours, islamic tours.