<?php
	$table="ksiegarnia";
	$Gatunek=$_GET['Gatunek'];
	$user="root";
	$pass="";
	$database="ksiegarnia";
	$adres="localhost";

	$conn = mysqli_connect($adres,$user,$pass,$database);//or die("You can't connect to the server");
	//@mysql_select_db() or die("Not found database");
	$query = "SELECT * FROM $table where Gatunek='$Gatunek'";
	echo "<Table border=\"1\"><tr><th>id_k</th><th>Tytul</th><th>Rok_wydania</th><th>Cena</th><th>Gatunek</th><th>Autor</th></tr>";
	if ($result = mysqli_query($conn, $query)) {
		while ($row = mysqli_fetch_assoc($result)) {
     		$id_k=$row["id_k"];
			$Tytul=$row["Tytul"];
			$Rok_wydania=$row["Rok_wydania"];
			$Cena=$row["Cena"];
			$Gatunek=$row["Gatunek"];
			$Autor=$row["Autor"];
			echo "<tr><td>";
			echo $id_k,"</td><td>",$Tytul,"</td><td>",$Rok_wydania,"</td><td>",$Cena,"</td><td>",$Gatunek,"</td><td>",$Autor,"</td></tr>";
		}
		mysqli_free_result($result);
		echo "</Table>";
	}
	mysqli_close($conn);
?>