Untitled

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "phpuzd";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT ID, Vardas, Pavarde, Lytis, Miestas, Hobiai, 'Apie save' FROM `anketa`";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["ID"]. " - Vardas: " . $row["Vardas"]. " - Pavarde: " .$row["Pavarde"]. " - Lytis: " .$row["Lytis"]. " - Miestas: " .$row["Miestas"]. " - Apie save: " .$row["Apie save"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>
<html>
	<head>
	</head>
	<body>
		<table border="3">
			<tr>
				<td>ID</td>
				<td>Vardas</td>
				<td>Pavarde</td>
				<td>Lytis</td>
				<td>Miestas</td>
				<!-- <td>Hobiai</td> -->
				<td>Apie save</td>
			</tr>
			<?php
				if(mysqli_num_rows($result) > 0){
					while($row = mysqli_fetch_assoc($result)){
						echo "<tr>
							<td>".$row["ID"]."</td>
							<td>".$row["Vardsa"]."</td>
							<td>".$row["Pavarde"]."</td>";
							if($row["Lytis"] == "v") echo "<td>Vyras</td>";
							else if($row["Lytis"] == "m") echo "<td>Moteris</td>";
							else echo "<td>Kita</td>";
							echo "<td>".$row["Mietas"]."</td>
							<td>".$row["Apie save"]."</td>
						</tr>";
					}
				}
			?>
		</table>
	</body>
</html>