	<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 lang_id='$lang' AND publisha='yes' ORDER BY priority";
			$result = mysql_query($sql);
	while ($myrow=mysql_fetch_array($result)) {
			$id=$myrow['insert_id'];
			$name=$myrow['name'];
			$description=$myrow['text'];
            $image=$myrow['image'];
			?>
 
<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 WHERE lang_id='$lang' ORDER BY id";
			$result5 = mysql_query($sql5);
	while ($myrow=mysql_fetch_array($result5)) {
			$seasonid=$myrow['insert_id'];
			$season=$myrow['name'];
			$date1=$myrow['date1'];
			$date2=$myrow['date2'];
?>
   
                        <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'];
?>
<?php if ($photo=='') { 
$photo=$company1;
}?>
   <?php include 'photo.php';?>
 <?php } ?>
  <div style="clear:both"></div>
  <hr>
 
 <?php
			$sql1 = "SELECT * FROM specscategories WHERE publish='yes' AND lang_id='$lang' ORDER BY priority";
			$result1 = mysql_query($sql1);
	while ($myrow=mysql_fetch_array($result1)) {
			$scatid=$myrow['insert_id'];
			$scategory=$myrow['title'];
?>
 
            
       <?php
	    	$result2 = mysql_query("SELECT * FROM specs WHERE room_id='$id' AND category_id='$scatid' AND lang_id='$lang'",$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' AND lang_id='$lang' ORDER BY priority";
			$result3 = mysql_query($sql3);
			while ($myrow=mysql_fetch_array($result3)) {
			$spec=$myrow['name'];
?>
 
                  <div> 
                    <?php echo $spec ?>
                  </div>
                  <?php } ?>
                  <hr>
                  <?php } ?>
                   
                  <?php } ?>
  <div style="clear:both"></div>                  

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