HOW CAN I FİX THAT ERROR SA:MP 🐧 #support-forum

HOW CAN I FİX THAT ERROR

billions-furniture-91478

02/13/2023, 6:24 PM

[ERROR] error #1054 while executing query "SELECT * FROM

players

WHERE name = `Acheron_Cleuts`": Unknown column 'Acheron_Cleuts' in 'where clause'

thousands-airplane-62273

02/13/2023, 7:11 PM

put the code too on your post

sparse-dusk-41601

02/13/2023, 9:33 PM

That means the player name doesn’t exist

sparse-dusk-41601

02/13/2023, 9:34 PM

add a statement if the query fails to allow the player to register

silly-electrician-10549

02/13/2023, 11:43 PM

Copy code

`%s`

Copy code

'%s'

gorgeous-baker-92777

02/14/2023, 8:47 AM

Still wrong

gorgeous-baker-92777

02/14/2023, 8:47 AM

Use mysql format and

'%e'

to escape strings

gorgeous-tomato-73021

03/10/2023, 2:28 PM

Copy code

c
format(query, sizeof query, "SELECT * FROM `players` where name = '%e"", name);

gorgeous-tomato-73021

03/10/2023, 2:28 PM

`` = columns/tables '' = values