getPlayerName with MySQL

[dawid4157]

Why this function does not work?

function zapytanie(player) 
    local playerName = getPlayerName(player) 
    local register = mysql_query(handler, "INSERT INTO `Players` SET `Nick` = ".. playerName .." ") 
    outputChatBox("Poprawne zapytanie") 
end 

When I set this:

function zapytanie(player) 
    local playerName = getPlayerName(player) 
    local register = mysql_query(handler, "INSERT INTO `Players` SET `Nick` = 'dawid4157' ") 
    outputChatBox("Poprawne zapytanie") 
end 

code work good. Why? How use getPlayerName correctly? Please help.

[Wei]

function zapytanie(player) 
    local playerName = getPlayerName(player) 
    local register = mysql_query(handler, "INSERT INTO `Players` SET `Nick` = `".. playerName .."` ") 
    outputChatBox("Poprawne zapytanie") 
end 

Try this

[dawid4157]

It`s not work. Maybe oher concept?

[Anubhav]

  
function zapytanie(player) 
    local playerName = getPlayerName(player) 
    local register = mysql_query(handler, "INSERT INTO `Players` SET `Nick`=? ", playerName ) 
    outputChatBox("Poprawne zapytanie") 
end 
  

[dawid4157]

Still no result.

[dawid4157]

I show all code:

local host = 'host' 
local user = 'user' 
local password = 'pass' 
local db = 'database' 
handler = mysql_connect(host, user, password, db) 
if (handler) then 
    outputChatBox("Connected to the Database!", getRootElement(), 255, 000, 000) 
    outputDebugString("Connected to the Database!") 
else 
    outputChatBox("No connected to the Database!") 
    outputDebugString("No connected to the Database!") 
end 
  
  
function zapytanie(player) 
    local playerName = getPlayerName(player) 
    local register = mysql_query(handler, "INSERT INTO `Gracze` SET `Nick`=? ", playerName ) 
    outputChatBox("Poprawne zapytanie") 
end 
  
  
  
addCommandHandler("sql", zapytanie) 

What is wrong?