commit 0228f6bb3e0e9280226db48e4471d38f1afaf279
parent bbaf41e512d1e8a86e7e23e73b4b799c79368e15
Author: LennartSchroot <[email protected]>
Date: Sun, 16 Apr 2023 17:50:19 +0200
login
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/login.php b/login.php
@@ -56,7 +56,7 @@
// create, prepare sql statement and execute sql statement
$sql = "select u.email, u.password, p.permission_id, p.permission_name
from user u
- join user_permission up on up.email = u.email
+ join user_permission up on up.user_id = u.user_id
join permission p on p.permission_id = up.permission_id
where u.email = ? ";
$stmt= $conn->prepare($sql);
