Checking MySQL Database

[xXMADEXx]

Hi guys, im trying to check my database, to see if the account exists. For some reason, it just keeps returning true, and i don't really know how to make it check if the account exists, and if it does then return true, but if it dosn't then return false...

Please help.

addCommandHandler("c", 
    function ( player, command, accountName ) 
        local v = dbExec ( dbc, "SELECT name FROM Accounts WHERE name=?", accountName ) 
        outputChatBox ( tostring ( v ) ) 
    end 
) 

[Castillo]

That's because:

Returns true unless the connection is incorrect, in which case it returns false.

You must use:

dbQuery 

[Jacob Lenn]

Better use

dbQuery 
dbPoll 

[xXMADEXx]

Oh thank you

[xXMADEXx]

Okey, so i updated the script, but its returning table data...

addCommandHandler ( "c", 
    function ( player, command, accnt ) 
        local new = dbQuery ( dbc, "SELECT name FROM Accounts WHERE name=?", accnt ) 
        outputChatBox ( tostring ( dbPoll ( new, -1 ) ) ) 
    end 
) 

[Castillo]

addCommandHandler ( "c", 
    function ( player, command, accnt ) 
        local new = dbQuery ( dbc, "SELECT name FROM Accounts WHERE name=?", accnt ) 
        local result = dbPoll ( new, - 1 ) 
        if ( type ( result ) == "table" and #result == 0 or not result ) then 
            outputChatBox ( "Not in table" ) 
        else 
            outputChatBox ( "In table" ) 
        end 
    end 
) 

[xXMADEXx]

Thank you very much , it works.

[Castillo]

You're welcome.