<table id="content" width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td> 
                <table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr valign="top">
    <td>
   <div style="padding-bottom:10px; padding-right:10px; text-align:justify;">
   <?php echo $description ?>
    </div>  
    
<?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'];
?>
<?php include 'lang.php';?> 
            
       <?php
	    	$result2 = mysql_query("SELECT * FROM specs WHERE room_id='$pid' AND category_id='$scatid'",$dbh);
			$myrow=mysql_fetch_array($result2); 
			$nu_row2 = mysql_num_rows($result2);
			?>         
            
                  <?php 
	if  ($nu_row2>0) {
	?>
           <strong><?php echo $scategory ?></strong> 
                  
                  <?php
			$sql3 = "SELECT * FROM specs WHERE room_id='$pid' 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'];
?>
<?php include 'lang.php';?> 
                  <div> 
                    <?php echo $spec ?>
                  </div>
                  <?php } ?>
                  <?php } ?>
                  <?php } ?>    
    </td>
    </tr>
    <tr>
    <td>
    <div>
    <?php
			$sql4 = "SELECT * FROM photos WHERE room_id='$pid' ORDER BY priority";
			$result4 = mysql_query($sql4);
			while ($myrow=mysql_fetch_array($result4)) {
			$photoid=$myrow['id'];
			$photo=$myrow['name'];
			$photo_en=$myrow['name_en'];
			$photo_de=$myrow['name_de'];
			$photo_fr=$myrow['name_fr'];
            $photo_it=$myrow['name_it'];
            $photo_es=$myrow['name_es'];
            $photo_ru=$myrow['name_ru'];
			$ppriority=$myrow['priority'];
?>
<?php include 'lang.php';?> 
<?php if ($photo=='') { 
$photo=$company1;
}?>
                 <?php include 'photo.php';?>
                  <?php } ?>
                  </div>
<div style="clear:both"></div>                  
    </td>
  </tr>
</table>
                 
                </td>
              </tr>
              <tr>
                <td>
				<?php 
			$sql6 = "SELECT * FROM prices WHERE room_id='$pid'";
			$result6 = mysql_query($sql6);
			$nu_row6 = mysql_num_rows($result6);
?>
        <?php if  ($nu_row6>0) {?>
        
 <?php if ($lang=='1') { $pricelist="Τιμοκατάλογος Ευρώ/νύχτα/μονάδα";  } ?>
 <?php if ($lang=='2') { $pricelist="Pricelist Euro/night/unit";  } ?>
 <?php if ($lang=='3') { $pricelist="Preisliste Euro/Übernachtung/Einheit";  } ?> 
 <?php if ($lang=='4') { $pricelist="Liste des prix Euro/nuit/unité";  } ?>
 <?php if ($lang=='5') { $pricelist="Listino prezzi notte/unità";  } ?>
 <?php if ($lang=='6') { $pricelist="Lista de precios noche/unidad";  } ?>
 <?php if ($lang=='7') { $pricelist="Цены Euro/Ночь/блок";  } ?>                          
                            
          <div>
          <strong><?php echo $pricelist ?></strong>
            </div>
        <table width="100%" border="0" cellspacing="1" cellpadding="4" class="text2">
        <tr valign="top"> 
          <?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'];
			$date1=$myrow['date1'];
			$date2=$myrow['date2'];
			$counts++;
?>   
<?php include 'lang.php';?>
          <td width="80" bgcolor="#<?php echo $color2 ?>">
		 <b><?php echo $season ?></b> <br>
         <?php echo $date1 ?>
          <br>
         <?php echo $date2 ?>
          </td>
       <?php } ?>     
  </tr>
      </table>
<table width="100%" border="0" cellspacing="1" cellpadding="4" class="text2">
  <tr valign="top"> 
          <?php
			$sql7 = "SELECT * FROM seasons ORDER BY id";
			$result7 = mysql_query($sql7);
	while ($myrow=mysql_fetch_array($result7)) {
			$seasonid=$myrow['id'];
?>              
          <td width="80" bgcolor="#<?php echo $color2 ?>">
		            
                           <?php
			$sql8 = "SELECT * FROM prices WHERE room_id='$pid' AND season_id='$seasonid'";
			$result8 = mysql_query($sql8);
	while ($myrow=mysql_fetch_array($result8)) {
			$price=$myrow['price'];
?>
        <?php echo $price ?>
<?php } ?>
         </td>
           <?php } ?> 
  </tr>
</table> 
<hr>                
<?php } ?>
</td>
              </tr>
              <tr> 
                <td> 
            <div align="center" class="divbutton">
               <a href="reservation.php?rid=<?php echo $pid ?>" class="button"><?php echo $textbutton1 ?></a> 
               <?php if ($resurl!='') { ?>
               &nbsp; &nbsp;
               <a href="<?php echo $resurl ?>" class="button"><?php echo $textbutton2 ?></a> 
              <?php } ?>
            </div>
                     </td>
              </tr>
            </table>