<select id="flat">
					<?php $filterflat = get_filterflat(); ?>
					<?php foreach ($filterflat as $post): ?>
				  	<option value="<?=$post["id"]?>"><?=$post["rooms"]?></option>
					<?php endforeach; ?>
				</select>
				<select id="metro">
					<?php $filtermetro = get_filtermetro(); ?>
					<?php foreach ($filtermetro as $post): ?>
					<option value="<?=$post["stationid"]?>"><?=$post["station"]?></option>
					<!-- <option value="taganka">Таганская</option>
					<option value="kurskay">Курская</option>
					<option value="poveleckay">Повелецкая</option> -->
					<?php endforeach; ?>
				</select>
				<?php $posts = get_posts(); ?>
				<?php foreach ($posts as $post): ?>
				<div id="items">
				  	<div class="item" data-color="<?=$post["id"]?>" data-shape="<?=$post["stationid"]?>">
					  	<div class="infoFlat">
					  		<h3> <?=$post["titleflat"]?> </h3>
					  		<h3><?=$post["titlemetro"]?></h3>
					  		<h3><?=$post["price"]?>.</h3>
					  		<p class="b1"><?=$post["date"]?></p>
					  	</div>
					  	<div class="itemText">
					  		<p><?=$post["text"]?></p>
					  	</div>
					</div>
				</div>	
				<?php endforeach; ?>

function get_posts() {
		global $connection;
		$sql = " SELECT * FROM orders_posts ORDER BY rand()";
		$result = mysqli_query($connection, $sql);
		$posts = mysqli_fetch_all($result, MYSQLI_ASSOC);
		return $posts;
	}

	function get_filterflat() {
		global $connection;
		$sql = "SELECT * FROM filterflat";
		$result = mysqli_query($connection, $sql);
		$filterflat = mysqli_fetch_all($result, MYSQLI_ASSOC);
		return $filterflat;
	}

	function get_filtermetro() {
		global $connection;
		$sql = "SELECT * FROM filtermetro";
		$result = mysqli_query($connection, $sql);
		$filtermetro = mysqli_fetch_all($result, MYSQLI_ASSOC);
		return $filtermetro;
	}

	function get_allFilters() {
		global $connection;
		$sql = "SELECT filterflat.id, filtermetro.stationid, : orders_posts.id FROM filterflatINNER JOIN filtermetro ON filterflat.id=filtermetro.stationid";

	}