sql karmaşık sorgu

 
  public function resourceControl($resources,$quantity,$free_rooms){ 
  				 
  		$y=0; 
  		for($j=0;$j<count($quantity);$j++){ 
  			$query=mysql_query("select * from facility where Quantity>='$quantity[$j]' && Resource_Id='$resources[$j]'"); 
  							 
  			while($a=mysql_fetch_assoc($query)){ 
  				$ar[$y]=$a['Room_Id'];//all rooms in query 
  				$y++;									 
  			}	 
  		} 
  					 
  		$result=array_count_values($ar);//if $ar count= count $quantity this room have select resources. 
  		$i=0; 
          foreach ($result as $key => $value) { 
  			if($value==$j){ 
  				$res[$i]=$key; 
  				$i++; 
  			} 
  		} 
    
  		 
  	return $res; 
  			 
  				 
  	}