<table id="content" width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td> 
       <?php
	   $search="%".$search."%";
	   $result1 = mysql_query("SELECT * FROM profil WHERE (name LIKE '$search' OR name_en LIKE '$search' OR name_de LIKE '$search' OR text LIKE '$search' OR text_en LIKE '$search' OR text_de LIKE '$search')",$dbh);
	   $myrow=mysql_fetch_array($result1); 
	   $nu_row1 = mysql_num_rows($result1);
						?>         
            
                  <?php 
	if  ( ( $nu_row1!=0)) {
	?>
   &raquo;  <a href="."><?php echo $pagehome ?></a>  
  <?php } ?>  
</td>
  </tr>
  <tr>
    <td> 
       <?php
	   $search="%".$search."%";
	   $result2 = mysql_query("SELECT * FROM siteinfo WHERE (location LIKE '$search' OR location_en LIKE '$search' OR location_de LIKE '$search')",$dbh);
	   $myrow=mysql_fetch_array($result2); 
	   $nu_row2 = mysql_num_rows($result2);
						?>         
            
                  <?php 
	if  ( ( $nu_row2!=0)) {
	?>
   &raquo;  <a href="location.php"><?php echo $pagelocation ?></a> 
  <?php } ?>  
  
  </td>
  </tr>
        <tr> 
          <td> 
            
            <?php
		$search="%".$search."%";
		$sql3 = "SELECT * FROM rooms WHERE (name LIKE '$search' OR name_en LIKE '$search' OR name_de LIKE '$search' OR description LIKE '$search' OR description_en LIKE '$search' OR description_de LIKE '$search') AND publisha='yes' AND publish='yes' ORDER BY priority";
		$result3 = mysql_query($sql3);
		while ($myrow=mysql_fetch_array($result3)){
		$count3++;
	    $id1=$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'];
?>
<?php include 'lang.php';?>
          </td>
        </tr>
        <tr> 
          <td> 
            &raquo; <a href="room.php?rid=<?php echo $id1 ?>"><?php echo $name ?></a> 
          </td>
        </tr>
        <tr> 
          <td> 
            <?php } ?>
          </td>
        </tr>
        <tr> 
          <td> 
            <?php
		$search="%".$search."%";
		$sql4 = "SELECT * FROM info WHERE (name LIKE '$search' OR name_en LIKE '$search' OR name_de LIKE '$search' OR description LIKE '$search' OR description_en LIKE '$search' OR description_de LIKE '$search') AND publish='yes' ORDER BY priority";
		$result4 = mysql_query($sql4);
		while ($myrow=mysql_fetch_array($result4)){
		$count4++;
		$icatid=$myrow['category_id'];
		
		$result5 = mysql_query("SELECT * FROM infocategories WHERE id='$icatid' AND publish='yes'",$dbh);
		$myrow=mysql_fetch_array($result5); 
		$category=$myrow['category'];
		$category_en=$myrow['category_en'];
		$category_de=$myrow['category_de'];
		$category_fr=$myrow['category_fr'];
        $category_it=$myrow['category_it'];
        $category_es=$myrow['category_es'];
        $category_ru=$myrow['category_ru'];
?>
<?php include 'lang.php';?>
          </td>
        </tr>
        <tr> 
          <td>
          &raquo; <a href="info.php?catid=<?php echo $icatid ?>"><?php echo $category ?></a> 
		  </td>
        </tr>
        <tr> 
          <td> 
            <?php } ?>
          </td>
        </tr>
        </table>