mysql help

[huyjvguyen]

i use it ? it's right?

  
function money(thePlayer, commandName) 
name = getPlayerName 
 local money = exports.mysql:query("SELECT `money` FROM `accounts` WHERE `id` = ' "..name .." ' ") 
if (money < 100) then outputChatBox("you are bad" , thePlayer ) 
else outputChatbox("you are handsome boy" , thePlayer) 
end 
end 
addCommandHandler("checkmoney", root, money) 
  

[LabiVila]

First, the second like should be like this: name = getPlayerName (thePlayer)

second, rather than exports.mysql:query you can use dbQuery (...) then get the result with dbPoll (thequery, -1)