commit 374a33f6836c9ce9d6d64acf71d7962dbf7a2dc1
parent 932f60a2875a71b611d5154bedc124114d3f940a
Author: MoiBaguette <gerco.v.woudenbergh@gmail.com>
Date: Sun, 16 Apr 2023 17:52:02 +0200
Merge branch 'tak' of https://github.com/friedelschoen/iwa-webapp into tak
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/back-up/login.php b/back-up/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);