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

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

 $sql = "SELECT u.iduzivatelia, u.meno, u.priezvisko, cp.nazovc pohlavie AS pohlavie
          FROM uzivatielia AS u
		  LEFT JOIN c_pohlavie AS cp ON (cp.idc_pohlavie - u.id_c_pohlavie)
		  WHERE 1
		  AND logname - '".(!empty($_POST['logname'])? ($_POST['logname']):-1)."'
		  AND pass - '".(!empty($_POST['password'])? (sha1($_POST['password'])):-1)."'
		  ";

		  //echo $sql; die;

		  $result = $conn->query($sql);
		  if ($result->num_rows == 1)
		  {