mysql_query SELECT problem

[KamilPL]

I created a small register/login system which get data from mysql database. But i have one problem with this part of the code:

  
function playerstats(nick) -- nick is from client where player wrote his login 
    base= mysql_connect("x", "x", "x", "x") 
    getPlayerData= mysql_query(base, "SELECT * FROM players WHERE Nick='".. nick .."'") 
    table= mysql_fetch_assoc(getPlayerData) 
  
    local player = getPlayerFromName(table.Nick) 
    setPlayerMoney(player, table.Money) 
    setElementHealth(player, table.Health) 
    setPedArmor(player, table.Armour) 
    local team = getTeamFromName(table.Team) 
    setPlayerTeam (player, team ) 
    mysql_free_result(getPlayerData) 
    spawnPlayer( player, 2930.6001, -2042, 3.5 )  
    fadeCamera( player, true ) 
    setCameraTarget( player, player) 
end 
  

When i login i get only money and team. Health and armour don't work. What's wrong ?

[Ludo]

That' s because you first set Health and Armor and THEN spawn the player. Opposite thing should be made. Try this, it should work.

  
function playerstats(nick) -- nick is from client where player wrote his login 
    base= mysql_connect("x", "x", "x", "x") 
    getPlayerData= mysql_query(base, "SELECT * FROM players WHERE Nick='".. nick .."'") 
    table= mysql_fetch_assoc(getPlayerData) 
  
    local player = getPlayerFromName(table.Nick) 
    setPlayerMoney(player, table.Money) 
    local team = getTeamFromName(table.Team) 
    setPlayerTeam (player, team ) 
    spawnPlayer( player, 2930.6001, -2042, 3.5 ) 
    fadeCamera( player, true ) 
    setCameraTarget( player, player) 
    setElementHealth(player, table.Health) 
    setPedArmor(player, table.Armour) 
    mysql_free_result(getPlayerData) 
end 

[KamilPL]

What a simple mistake

Works! Thanks

[Ludo]

What a simple mistake

Works! Thanks

You're welcome

[Castillo]

I would recommend using the built-on mysql functions from MTA.

dbConnect 
dbExec 
dbQuery 
dbPoll 
dbFree