diff --git a/public/login.php b/public/login.php
index c7ae80f..967a9b6 100644
--- a/public/login.php
+++ b/public/login.php
@@ -9,14 +9,14 @@ if ($_SERVER['REQUEST_METHOD'] == 'POST') {
     
     if (!empty($name) && !empty($password)) {
         // etsi käyttäjä
-        $sql = "SELECT * FROM teachers WHERE name = '{$name}'";
+        $sql = "SELECT * FROM teachers WHERE username = '{$name}'";
         $result = $conn->query($sql);
 
         if ($result->num_rows > 0) {
             $user = $result->fetch_assoc();
 
             // tarkista salasanan hash, php defaultti (bcrypt)
-            if (password_verify($password, $user['password'])) {
+            if (password_verify($password, $user['password_hash'])) {
                 $_SESSION['user_id'] = $user['id'];
                 $_SESSION['user_name'] = $user['name'];
                 header('Location: ../public/admin.php');