	<h1><a href="#"><?php echo $pageaccommodation ?></a></h1>
	<div>
<?php $photopath="accommodation/"; ?>
<?php include 'inphoto.php';?>
<div class="main">	
<?php echo $activity1 ?>
<hr>
		    <?php
			$sql = "SELECT * FROM rooms WHERE publish='yes' AND publisha='yes' ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$id=$myrow['id'];
			$name=$myrow['name'];
			$name_en=$myrow['name_en'];
			$name_de=$myrow['name_de'];
			$name_fr=$myrow['name_fr'];
            $name_it=$myrow['name_it'];
            $name_es=$myrow['name_es'];
            $name_ru=$myrow['name_ru'];
            $name_zh=$myrow['name_zh'];
			$description=$myrow['description'];
			$description_en=$myrow['description_en'];
			$description_de=$myrow['description_de'];
			$description_fr=$myrow['description_fr'];
            $description_it=$myrow['description_it'];
            $description_es=$myrow['description_es'];
            $description_ru=$myrow['description_ru'];
            $description_zh=$myrow['description_zh']; 
            $image=$myrow['image'];
			?>
<?php include 'lang.php';?> 
             
<div style="padding:5px; border:1px solid #<?php echo $color1 ?>; background:#<?php echo $color2 ?>" class="text2">

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr valign="top">
    <td width="90">
<?php if ($image==yes) { ?>
   <a id="thumb<?php echo $id ?>" href="<?php echo $photoroot ?>/images/rooms/<?php echo $id ?>.jpg" class="plinks" onclick="return hs.expand(this)"><img src="<?php echo $photoroot ?>/images/rooms/thumbs/<?php echo $id ?>.jpg" alt="<?php echo $name ?>" width="80"></a> 
<?php }?>    
    </td>
    <td>
<span class="titles"><?php echo $name ?></span>    
    </td>
  </tr>
</table>

 <div style="padding-top:5px">
 <?php echo $description ?>
</div>

</div>

				<?php 
			$sql6 = "SELECT * FROM prices WHERE room_id='$id'";
			$result6 = mysql_query($sql6);
			$nu_row6 = mysql_num_rows($result6);
?>
                  <?php 
	if  ($nu_row6>0) {
	?>
                 
                  <div style="margin-top:5px; margin-bottom:5px; border:1px solid #<?php echo $color5 ?>;" class="text2">
                    <table width="100%" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <?php
			$sql5 = "SELECT * FROM seasons ORDER BY id";
			$result5 = mysql_query($sql5);
	while ($myrow=mysql_fetch_array($result5)) {
			$seasonid=$myrow['id'];
			$season=$myrow['season'];
			$season_en=$myrow['season_en'];
			$season_de=$myrow['season_de'];
			$season_fr=$myrow['season_fr'];
            $season_it=$myrow['season_it'];
            $season_es=$myrow['season_es'];
            $season_ru=$myrow['season_ru'];
            $season_zh=$myrow['season_zh'];
			$date1=$myrow['date1'];
			$date2=$myrow['date2'];
?>
  <?php include 'lang.php';?> 
                        <td valign="top"> 
                          <table border="0" cellspacing="1" cellpadding="1" width="100%">
                            <tr> 
                              <td style="height:30px; padding: 5px" valign="top" bgcolor="#<?php echo $color2 ?>"> 
                                <?php echo $date1 ?> 
                                <br>
                                <?php echo $date2 ?> 
                              </td>
                            </tr>
                            <tr> 
                              <td style="padding: 5px" valign="top" bgcolor="#<?php echo $color2 ?>"> 
                                <?php
			$sql7 = "SELECT * FROM prices  WHERE season_id='$seasonid' AND room_id='$id'";
			$result7 = mysql_query($sql7);
	while ($myrow=mysql_fetch_array($result7)) {
			$price=$myrow['price'];
			$available=$myrow['available'];
?>
  <?php echo $price ?> 
  <?php } ?>
  &#8364;
                                
                              </td>
                            </tr>
                          </table>
                        </td>
                        <?php } ?> 
                      </tr>
                      </table>
                  </div>
                  <?php } ?>
             
  <?php
			$sql4 = "SELECT * FROM photos WHERE room_id='$id' ORDER BY priority";
			$result4 = mysql_query($sql4);
			while ($myrow=mysql_fetch_array($result4)) {
			$photoid=$myrow['id'];
			$photo=$myrow['name_en'];
?>
<?php if ($photo=='') { 
$photo=$company1;
}?>
   <?php include 'photo.php';?>
 <?php } ?>
  <div style="clear:both"></div>
  <hr>
 
 <?php
			$sql1 = "SELECT * FROM specscategories WHERE publish='yes' ORDER BY priority";
			$result1 = mysql_query($sql1);
	while ($myrow=mysql_fetch_array($result1)) {
			$scatid=$myrow['id'];
			$scategory=$myrow['category'];
			$scategory_en=$myrow['category_en'];
			$scategory_de=$myrow['category_de'];
			$scategory_fr=$myrow['category_fr'];
            $scategory_it=$myrow['category_it'];
            $scategory_es=$myrow['category_es'];
            $scategory_ru=$myrow['category_ru'];
            $scategory_zh=$myrow['category_zh'];
?>
<?php include 'lang.php';?> 
            
       <?php
	    	$result2 = mysql_query("SELECT * FROM specs WHERE room_id='$id' AND category_id='$scatid'",$dbh);
			$myrow=mysql_fetch_array($result2); 
			$nu_row2 = mysql_num_rows($result2);
						?>         
            
                  <?php 
	if  ($nu_row2>0) {
	?>

                  <div style="padding-bottom:5px"> 
                   <strong><?php echo $scategory ?></strong>
                  </div>
                  
                  <?php
			$sql3 = "SELECT * FROM specs WHERE room_id='$id' AND category_id='$scatid' ORDER BY priority";
			$result3 = mysql_query($sql3);
			while ($myrow=mysql_fetch_array($result3)) {
			$spec=$myrow['name'];
			$spec_en=$myrow['name_en'];
			$spec_de=$myrow['name_de'];
			$spec_fr=$myrow['name_fr'];
            $spec_it=$myrow['name_it'];
            $spec_es=$myrow['name_es'];
            $spec_ru=$myrow['name_ru'];
            $spec_zh=$myrow['name_zh'];
?>
<?php include 'lang.php';?> 
                  <div> 
                    <?php echo $spec ?>
                  </div>
                  <?php } ?>
                  <hr>
                  <?php } ?>
                   
                  <?php } ?>
  <div style="clear:both"></div>                  

            <?php }?>
	</div>	
	</div>
