Last player name to db

[Annas]

How can i add player last name to the database

i tried this , but it's not working

  
function saveData() 
    local account = getPlayerAccount(source) 
    if (not account or isGuestAccount(account)) then return end 
    local lastname = getPlayerName(source) 
        -- Last name 
    dbExec(db, "UPDATE banking (name, lastname) VALUES(?)", account, lastname) 
end 
addEventHandler("onPlayerQuit", root, saveData) 
addEventHandler("onPlayerLogout", root, saveData) 

Sorry if it's wrong board

HELP ME PLEASE

[Mann56]

  
 dbExec(db, "UPDATE banking SET lastname=? WHERE name=? ", lastname, account) 
  

[KariiiM]

Hey, what you have coded was totally, wrong, try that

function saveData() 
    local account = getPlayerAccount(source) 
    if (not account or isGuestAccount(account)) then return end 
    local lastname = getPlayerName(source) 
        -- Last name 
    dbExec(db, "UPDATE banking SET lastname=? WHERE name='"..tostring(account).."'LIMIT 1", lastname) 
end 
addEventHandler("onPlayerQuit", root, saveData) 
addEventHandler("onPlayerLogout", root, saveData) 

[Mann56]

Hey, what you have coded was totally, wrong, try that

function saveData() 
    local account = getPlayerAccount(source) 
    if (not account or isGuestAccount(account)) then return end 
    local lastname = getPlayerName(source) 
        -- Last name 
    dbExec(db, "UPDATE banking SET lastname=? WHERE name='"..tostring(account).."'LIMIT 1", lastname) 
end 
addEventHandler("onPlayerQuit", root, saveData) 
addEventHandler("onPlayerLogout", root, saveData) 

Ah i forgot the tostring()

Btw dude, i think he has set variable account with name and not lastname

[KariiiM]

By the way, It won't works, if your table is empty.

[TAPL]

getPlayerAccount does not return account name, you must use getAccountName to get the account name.