emil92b
Intermediate OT User
im trying to make a query that deletes the players id but also checks that the password of that players account is correct
but i get this error
and if i remove id
i get
SQL:
DELETE id FROM players INNER JOIN accounts ON accounts.id = players.account_id WHERE players.id = :playerid AND accounts.password = :password
but i get this error
Code:
Error - SQLSTATE[42S02]: Base table or view not found: 1109 Unknown table 'id' in MULTI DELETE
and if i remove id
i get
Code:
Error - SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INNER JOIN accounts ON accounts.id = players.account_id WHERE players.id = ? AND' at line 1
Last edited: