<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Web management</title>
<link rel="stylesheet" href="styles.css" type="text/css">
<?php include 'codes.php';?>
</head>
<body text="#000000" style="margin:0">
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td>
    
<div><img src="img/frame-list.png" width="180" height="37" alt=""></div>
<div class="frame">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="text">
        <tr> 
          <td> 
            <?php
							  $count1=0;
		$search="%".$search."%";
		$sql1 = "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";
		$result1 = mysql_query($sql1);
		while ($myrow=mysql_fetch_array($result1)){
		$count1++;
	     $id=$myrow['id'];
	     $name=$myrow['name'];
		 $image=$myrow['image'];
		 $publish=$myrow['publish'];
		 $priority=$myrow['priority'];
?>
          </td>
        </tr>
        <tr> 
          <td><?php include 'roomin.php';?> </td>
        </tr>
        <tr> 
          <td> 
            <?php } ?>
          </td>
        </tr>
        <tr> 
          <td> 
            <?php
							  $count2=0;
		$search="%".$search."%";
		$sql2 = "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";
		$result2 = mysql_query($sql2);
		while ($myrow=mysql_fetch_array($result2)){
		$count2++;
	    $id=$myrow['id'];
		$category_id=$myrow['category_id'];
		$name=$myrow['name'];
		$description=$myrow['description'];
		$priority=$myrow['priority'];
		   
		$showdesc=substr($description, 0, 100);
?>
      <?php
            $result = mysql_query("SELECT * FROM infocategories WHERE id='$category_id'",$dbh);
			$myrow=mysql_fetch_array($result); 
			$catid=$myrow['id'];
			$cat=$myrow['category'];
			
?>

          </td>
        </tr>
        <tr> 
          <td><?php include 'infoin.php';?>
			</td>
        </tr>
        <tr> 
          <td> 
            <?php } ?>
          </td>
        </tr>
        <tr> 
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td align="center">
		  <?php
$count=$count1 + $count2
      ?>
		   <b> 
            <?php echo $count ?>
            </b></td>
        </tr>
      </table>
</div>
</td>
  </tr>
</table>
<?php include 'menudown.php';?>
</body>
</html>
